Parsing Excel with ASP

stscac · 05-22-2007, 10:41 AM

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

Code:

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.

-Steve

monaco · 05-22-2007, 11:42 AM

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 · 05-23-2007, 07:20 AM

Still looking for answers.

-Steve

05-22-2007, 10:41 AM	#1 (permalink)
stscac A Wealth of Knowledge Join Date: Aug 2004 Posts: 3,794 47.60 NP$ (Donate)	Parsing Excel with ASP 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 Code: 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. -Steve __________________ Follow Me on Twitter:

05-22-2007, 11:42 AM	#2 (permalink)
monaco NamePros Regular Join Date: Jul 2005 Location: Tucson, AZ Posts: 695 314.80 NP$ (Donate)	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? __________________ My Website \| My Blog

05-23-2007, 07:20 AM	#3 (permalink)
stscac A Wealth of Knowledge Join Date: Aug 2004 Posts: 3,794 47.60 NP$ (Donate)	Still looking for answers. -Steve __________________ Follow Me on Twitter:

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)