The only way you can ever query an ODBC datasource. Use SQL. Think of the columns in the spreadsheet as fields and the rows as records. I don't know if it will work if you have more than one worksheet in the file, you will have to research this. You might try specifying the worksheet the same way that you do in Excel macros. Try
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.