Forum Moderators: open

Message Too Old, No Replies

Access to MySQL conversion?

How can I do it?

         

HockeyFighter

10:33 pm on Apr 2, 2006 (gmt 0)

10+ Year Member



I need to convert a rather large database to MySQL from Access, but dont know where to start. I've searched around and all I can find are expensive tools, or free ones that seem pretty "cheap".

Does anyone know of a method, or a tool I can use to convert an access db to mysql?

Thanks!

txbakers

11:46 am on Apr 3, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I did it by exporting all the Access tables to CSV files, then importing them into mySQL one at a time.

There was no easy way.

HockeyFighter

11:07 pm on Apr 4, 2006 (gmt 0)

10+ Year Member



I went to export and dont see a Windows/Dos CSV... will mysql be able to handle excel format csv?

txbakers

2:23 am on Apr 5, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Yes, it will import CSV files.