The best way I've found to convert MS Access to mySQL is via ODBC. 1. Just set up ODBC on Windows (an easy install process - just run the install program that you can download from MS)
2. Install MyODBC (you can download this from MySQL's site - somewhere in their downloads section) 3. Go into Control Panel-->ODBC. 4. Set up a new ODBC connection using the mySQL driver and have it connect to your MySQL database. 5. Open up your Access database, and go to the File menu, and choose to Export your tables. 6. In the drop-down list of exportable formats, you can find "ODBC Datasource" at the very bottom. Choose that and you'll be able to select the MySQL ODBC connection you set up. From there, exporting can take merely seconds to fully reconstruct a whole table with data. Microsoft did a pretty good job on this one. - Jonathan -----Original Message----- From: mweb [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 7:45 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP] Access to MYSQL via ODBC? GREAT, THANK YOU! Now the only step left is how to convert (on Linux) the MS access database to MySQL...How? mweb > ---------- Initial message ----------- > > From : "Andrew Hill" <[EMAIL PROTECTED]> > To : "mweb" <[EMAIL PROTECTED]>, "phplist" <[EMAIL PROTECTED]>, "mysqllist" <[EMAIL PROTECTED]> > Cc : > Date : Tue, 13 Nov 2001 10:27:15 -0500 > Subject : RE: [PHP] Access to MYSQL via ODBC? > > Sure, this is entirely possible. > Configure PHP --with-iodbc as per the HOWTO at www.iodbc.org and then > install the MyODBC driver. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
