Showing posts with label Access 2003. Show all posts
Showing posts with label Access 2003. Show all posts

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!