Errors Reading excel file

[netcomp]

Hi there, first time poster...long time lurker ;-)

Not sure why but I get errors when I add the 'where' clause to my select statement. Any ideads why this is happening - been researching for hours...

here's a snippet of the code:

oNoun = Request.Form("noun")
response.Write(oNoun)

strSelect = "Select modifier from [sheet1$] "
'strSelect = strSelect & " where noun = " & oNoun


Set oConnDICT = Server.CreateObject("ADODB.Connection")
oConnDICT.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
               "Data Source=" & Session("dict_full_path_name") & ";" & _
               "Extended Properties=""Excel 8.0;HDR=YES;"""
Dim oRSDICT
Set oRSDICT = Server.CreateObject("ADODB.Recordset")
oRSDICT.Open strSelect, oConnDICT

If Not oRSDICT.EOF then
	arroRSDICT = oRSDICT.GetRows()
End If

[jhardman]

Just an observation, you have written the query as if the noun column contains a number. If that is correct, then it should work. If the noun column should contain other data, a string for example, then the clause should end as follows:

strSelect = strSelect & " where noun = '" & oNoun & "'"

Let me know if this helps.

Jared

[netcomp]

You are exactly correct Jared. I found it about two minutes after I posted my question and forgot to update the thread.

Thanx for taking the time.