Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using ADO to Excel with this Query will not work?
F10 is definitely numeric ?
Can you show the next couple of lines where you're accessing the resultset ? Tim "todtown" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use MS Query to query data within the current work book | Excel Discussion (Misc queries) | |||
Cannot get Query Wizard to work in Excel | Excel Discussion (Misc queries) | |||
Excel Query Does not Work | New Users to Excel | |||
web query on EXCEL does not work. Why? | Excel Discussion (Misc queries) | |||
Access query does not work in Excel | Excel Programming |