I'm new to MySql as well but the "LOAD DATA" statement is probably what your looking for. It's a bulk loader and dumps the data from a flat file into a designated table for you. You could easily automate this by writing a simple perl script(probably php also but im not to familiar with that language yet) to connect to access,create and load flat files upon closing you could connect to mysql and run the "LOAD DATA" and point to the directory where you just saved the flat files from access. Course the files will have to be in a particular format tab delimited if im correct with each line ending with linefeed. Maybe some MySql veteran would like to add to this or make correction to what I have stated. Hopefully this will get you going in the right direction.
----- Original Message ----- From: "Arthur Klimowicz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, December 21, 2003 2:30 PM Subject: Convert MS Access to MySql > I need to convert an MS Access database to MySql. I would like to know the > best way to do this. I was going to write an asp or php script that would > read the MS Access db row by row and insert into the MySql db row by row. Is > that the only way to move the data from the one db to the other? > > Many thanks > Arthur > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
