January 3, 2004

ODBC MySQL Access (Wow!)

I can't believe it took me so many years to figure this out. Once you have the ODBC connection set up, you can do Excel-esque editing. The trick is not to use Excel, but to use Access.

Fire up MS Access and start a new database, right click on the staging area and click on Link Tables.... In the "Files of type:" drop box select ODBC Databases().

Now, select the Machine Data Source tab and you should see the database of interest.

The selected tables will available for editing. Each recorded is updated as you exit the field. This is very nice! You can do update queries using Access' nice interface. It is all very beautiful.

Posted by torque at January 3, 2004 6:05 PM | TrackBack
Post a comment

Remember personal info?