Using ADO to Excel with this Query will not work?
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
|