Using ADO to Excel with this Query will not work?

  • Thread starter Thread starter todtown
  • Start date Start date
T

todtown

I'm using ADO inside Excel to get data from another Excel workbook.

Using either the ODBC Driver for Excel or the OLE DB for Jet, I can do
this with success:

sql = "SELECT * FROM Sheet1$ WHERE F7 = 'Value'"

rs.Open sql, cn

I can use this sql, too:

sql = "SELECT * FROM Sheet1$ WHERE F7 = 'Value' AND F16 LIKE '%Value
%'"

But when I try to sum like this:

sql = "SELECT SUM(F10) FROM Sheet1$ WHERE F7 = 'Value' AND F16 LIKE
'%Value%'"

I get Null.

What should I do?

tod
 
F10 is definitely numeric ?

Can you show the next couple of lines where you're accessing the resultset ?

Tim
 
Back
Top