Parsing Excel with ASP

[stscac]

Looking for a hand parsing Excel with ASP. I just started to work with ASP this month and now I've been assigned stuff like the following. Probably not too hard for someone that knows ASP in and out, but for me

strSQL = "SELECT * FROM A1:Z200 WHERE The_Number <> 'Number 6'"

The_Number is a defined cell in excel. I have replaced the actual contents with "The_Number" to protect the integrity of my employer.

The error is 0x80040E10 "Too Few Parameters"

I'll be giving a small bounty to the person that gets this to work. Reply and I will get back to you.

:tu:

-Steve

 

[monaco]

I'm confused with what The_Number really is...if it's just a header name, you probably have something wrong. Try using the column index, like "...WHERE B <> 'Number 6'.

Did you somewhere else in the code map that column index to the index in the excel file?

 

[stscac]

Still looking for answers. :tu:

-Steve