Excel System.Data.OleDb.OleDbException: No value given for one or more required param

Hi

I d like to select data from an excel file with sql commands.

Code:

System.Data.OleDb.OleDbCommand("Select COUNT(*) FROM [Map1$A:A]", Con)

This works. it returns me the number of values from column A,
But now i want to add a WHERE and that doesn't work:

Code:

System.Data.OleDb.OleDbCommand("Select COUNT(*) FROM [Map1$A:A] WHERE A=`1`",Con)

Anyone knows, what's my mistake The error message is:

Code:

No value given for one or more required parameters.

cheers

newc0mer

.NET Development32

I believe provider does not recognize what is A column in your case. Try next

Select COUNT(*) FROM [Map1$A:A] WHERE [Map1$A:A]=`1`"

you're right with your interpretition:
http://www.xtremevbtalk.com/showthread.php t=275002&highlight=newc0m0r

And just to clarify, if your Excel connection string contains 'HDR=Yes' then valid columns would be in the first row of the specified Worksheet (or Range). Otherwise, (HDR=No) the column names default to F1, F2, F3, etc.