Posted by Bruce A. Julseth on 03/23/07 20:51

"Richard Formby" <rf@invalid.com> wrote in message
news:IPHMh.645$M.494@news-server.bigpond.net.au...
> 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.
>

Yah, I thought about that. I could import the .csv in to MySQL as a single
Table (as it now), then read it and convert it to the relational database
(which is the new design). The "Minor" problem is that I need to continue to
use the MS Access database while developing the "New Design" web system.
Once the new system is working, I'd have to import a second time. No big
deal, I guess.

[Back to original message]