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!

1 comment:

Andy Scaife said...

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.