ODBC.XLA Info

[MoonMullen]

Does anybody know where I can any information on how to use the ODBC add-in file? A working procedure would be great, yet I am willing to get anything I can find. MS Knowledge Base search did not give me any hits back. I want to run some queries against an Access database and have the result be populated straight into a worksheet. Any ideas??I

 

[ETID]

You might have to install more office components, but it's fairly staight forward...

In excel select data from the menu then get external data, new data base query, when the db query window opens you should see a list of data base types, select MS Access database* then select the path to your access mdb. You should then see a list of the tables and queries in the MDB.
A wizard will get you started but if your query is too complex it would ask you if you want to use MS Query instead, it's like a psudo access interface, but first time through, keep it simple and let the wizard walk you through returning the data to excel, once your data returns you can set properies of the query by right clicking in the data and choosing properties...for stuff like autofill formulas on refresh!

Hope this helps you get started