But let your communication be Yea, yea; Nay, nay: for whatsoever is more than these cometh of evil
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.

mysqlrev.png

Related Posts: A database driven epidemiological questionnaire, Once again genetic testing, On display – the masterclass, bLOG tOOL
Categories: Genetics + Biology
Keywords:
Trackback: http://www.wjst.de/blog/blog/2006/11/07/convert-an-accessr-database-into-mysql-format/


Comments are closed.