Tuesday, November 7th, 2006
Convert an Access(R) database into mySQL format
That should be a pretty straightforward task: Open in Access(R) the export function, select ODBC and send the tables to your local MySQL installation. This fails, however, on my system without any useful error message.
Access2MySQL(R) of DMSoft(R) does the job, costs 55$. The trial version stops after transfering 10 datasets; nevertheless the newly created database allows an hazzle-free phpMyAdmin import of .csv exported data.
Related Posts: A database driven epidemiological questionnaire, Once again genetic testing, On display – the masterclass, bLOG tOOL