Posted by Richard Formby on 03/23/07 03:28

Bruce A. Julseth wrote:

>I need to convert an MS Access database (Single Table) to MySQL (relational
>set of tables). As such, I think I'm going to have to get the data from the
>MS Access table and write code to convert it to MySQL. I "think" I need an
>ODBC connection to the MS Access table and tools to return a recordset.
>Once I have the recordset, I can break it and store in the MySQL database
>tables. That should be fairly straight forward.
>
> So, how get at the MS Access database and return a recordset? Or, can
> someone point me to tutorial?

MS Access will export a database table to a .csv file.
--
Richard.

[Back to original message]