Juan
06-08-2001, 10:24 AM
Anyone knows how to do this?
 | View Full Version : Convert Access to MySQL Madman2020 06-08-2001, 11:05 AM Originally posted by Juan Anyone knows how to do this? I hate to be so blunt... But good luck. Even if Access is able to dump data, to convert it to MySQL would be insane by hand. Unless, someone knows of or hows a script that would do so? jks 06-09-2001, 11:56 PM Originally posted by Juan Anyone knows how to do this? It's quite easy actually. You take a Wintel computer and add an ODBC driver for MySQL. Then you open Access and load in your database. Then simply save it - and choose ODBC - MySQL in the Save dialog (enter the correct ip, username and password for MySQL of course) - and that should be it. -- Jens Kristian Søgaard, Mermaid Consulting I/S, jens@mermaidconsulting.dk, http://www.raqsupport.net/ jtan15 06-10-2001, 12:51 AM You might want to check out this page ... http://www.mysql.com/downloads/contrib.html#SEC593 I saw an Access -> mySQL converter listed there. kunal 06-10-2001, 01:40 AM its pretty easy actually.. looks complicated i agree.. but whn implemented is easy... just export your access dbase as a text file.. and then run a php script to open the file and write to mysql... simple as that. mpkapadia 06-10-2001, 10:27 AM I have done it the way Jks has said on live data that was to actually needed to go to mysql, And it just worked fine, It is really simple and worked very fine for us. Rgds Manish Kapadia porpoise 08-24-2001, 06:13 PM Have a look at: http://www.accessmysql.com/ |