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]
