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 ( for accessing MS Access files (.mdb or .accdb) with ODBC.