Re: Convert MS Access to MYSQL
On Friday, January 30, 2004, at 03:12 AM, [EMAIL PROTECTED] wrote: There was some discussion in December of converting MS Access databases to Mysql and the DBManager program was recommended. I have recently converted access to mysql. I used access to import a CSV file and ensured all data was in the right place. I then built a table in mysql ensuring that all columns were in the same order as the access table (and of the correct format) I then used a plugin for access called MyAccess (shareware available via mysql.com), it enables you to use access as your GUI to mysql. I then simply used access to copy from one table to the other. It was a very text heavy import to deal with, with hundreds if not thousands of illegal characters that would corrupt a mysql db. Myaccess escaped them all for me. It was dead simple and I'm no techie. Job done - in about an hour. Mat -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Convert MS Access to MySql
Hi Arthur, Dbtools is a free product and it will do the conversion for you. http://www.dbtools.com.br/EN/index.php We have had success converting from MSAccess to MySQL in the past with it. Regards, Matt -Original Message- From: Arthur Klimowicz [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 11:00 AM To: [EMAIL PROTECTED] 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Convert MS Access to MySql
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]
Re: Convert MS Access to MySql
Arthur On converting data from MS Access. I've done this several times myself, and found the easiest way is to: 1. Create your mySQL database tables 2. Define a DSN (ODBC Connection) from your workstation to the mySQL database 3. Link the mySQL tables into your MS Access database 4. Copy the content over to mySQL http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html -Martin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]