QUERYING FROM EXCEL AS THE DATASOURCE

[kingjjx]

Hi, how can you use Excel as the datasource and query from it ?

thanks
-jon

 

[Guest_imported]

Create an ODBC datasource the same way you created one for your database. But, use the ODBC driver for Excel. It comes with WinNT and Win2000.

 

[kingjjx]

how do you actually query from it though ?
how do i write the select statements ?

 

[Guest_imported]

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

http://www.microsoft.com

or msdn.microsoft.com for more info.

 

[Extras]

Check out CFComet - they have a really good example!

http://www.cfcomet.com/Excel/index.cfm?ArticleID=0239B2E5-5FED-11D3-B3E9004033E03EF9

 

[mcsolas]

or maybe output it to a csv file and import it into access.. i did that the other day and it worked ok

 

[Extras]

Hmmm...

CFComet seemed to mention that you could use the name of the worksheet for the table name...