Re: convert Access db to Mysql how to

[Jay Alverson]

You can export a table by hand (try a small one to test), I know I did it last night.

Open Access, select a small table (or create one by copying one and emptying it out). Select that table by clicking on it once. Right click with the mouse and go down to EXPORT.

In the dialog box go down to the SAVE AS TYPE and find ODBC Databases (should be near the bottom of the list).

Export box pops up asking you what you want to call the table in MysQL. Just use the default for now. Next it will ask you for a Data Source Name. If you don't know how to use this, then hit CANCEL and learn how to create a DSN, from the ODBC utility in Control Panel. It's very easy.

If you have a DSN for MySQL then find the DSN and click on it to select it and then click OK.

It'll take a few seconds to export the data to MySQL.

This basically the same as using the Access DoCMD.TransferDatabase() method in VBA.

You can look at the Access VBA Help file that comes with access to get an example of how to do it programmatically.


>

Thanks, Jay