Excel

[winapi]

Hello, I am use to using the RDC object in visual basic to read access databases.
data.sql="Select * from (Field Name)"
data.refresh
is there anyway possible to use the ODBC to link into a Excel spreadsheet and use similar select statements.
Thanks
Richard Lange

[JHausmann]

Well, I can set up an Excel DSN, via the ODBC control panel. I have no idea on how I would use it though....

[Rob Gray]

why not try tackling from a different perspective.


make a tabke in microsoft query, which you can then access in excel and any other app.