In the Import window click as shown to connect to a ODBC source. Scroll all the way down, last item.
This opens the Select Data Source window where you can use the existing ones are create a brand new DSN.
Have fun!
Thursday, September 4, 2008
How do I connect to ODBC data in MS Access?
In MS Access you click on File | Get External Data | Import...
In the Import window click as shown to connect to a ODBC source. Scroll all the way down, last item.
This opens the Select Data Source window where you can use the existing ones are create a brand new DSN.
Have fun!
In the Import window click as shown to connect to a ODBC source. Scroll all the way down, last item.
This opens the Select Data Source window where you can use the existing ones are create a brand new DSN.
Have fun!
There is a guide here (http://www.easysoft.com/products/data_access/odbc-access-driver/getting-started.html for accessing MS Access files (.mdb or .accdb) with ODBC.
ReplyDelete