The Jonathan Tutorial Access -2- MySQL in 8 Not-Extremely-Easy-But-Not-Hard Steps
1. Go to mysql.com 2. Download and install MyODBC 3. Set up a new ODBC connection for the new mySQL server 4. Open up the database in access 5. Go to the File menu and choose to Export (Tables?) 6. At the bottom of the list of available formats to export to, there should be an ODBC data source or something to that effect. 7. You should be able to find the new ODBC connection you set up in step 3 using the dialog boxes that pop up. 8. Press OK and presto - your entire Access table structures and data are now in mySQL. Congratulations. - Jonathan -----Original Message----- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Monday, October 22, 2001 2:12 PM To: [EMAIL PROTECTED] Subject: MS Access to MySQL conversion? How? I am new to this fast database and love MySQL, but I need to know how to import or convert Access database to MySQL. ANyone know how I would go about that? Also this is for a web site and I need to change the asp code to PHP. Its not a lot, only a few pages, but its a headache for someone that has never done it before Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 --------------------------------------------------------------------- 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