How do I import my Access database into MySQL? — OZONE Asylum, home of the Mad Scientists

FAQ

How do I import my Access database into MySQL?

This page's ID: 5842

You are editing "How do I import my Access database into MySQL?"

Who can edit an FAQ?	Anyone registered may edit an FAQ.

Your User Name:
Your Password:
Login Options:	Remember Me On This Computer

Your Text: Insert Slimies » Insert UBB Code » Close Last Tag \| All Tags UBB Help	As a lot of people are working on migrating from ASP/Access to PHP/MySQL these kinds of problems crop up. There are a number of solutions: ----------------------- [b]MyODBC[/b] MyODBC is the driver which allows you to hook into the ODBC database API (found in Winows and Unix) which should make exporting possible. 1. Select your table 2. Go to File >> Export 3. Then in the 'Save as type' drop down scroll down to ODBC databases 4. The export dialogue opens asking: 'Export TABLE to ........ in ODBC Database' where you can select a new name if you want then click OK. 5. You now get the 'Select Data Source' dialogue box. 6. Select the 'Machine Data Source' tab. If MyODBC has been installed properly it should show up here. 7. If it can't connect to the MySQL database it will bring up the DSN configuration box and you can make sure the settings are right (or add your settings). If you are still haivng toruble make sure Apache and MySQL are running. [url=http://www.mysql.com/products/myodbc/]MySQL® Connector/ODBC[/url] - the main MyODBC page with links to the lastest versions. ----------------------- [b]Access Dump[/b] If you don't have Access or you run into difficulties then Access Dump can be used to convert the files. [url=http://www.intranet2internet.com]Intranet 2 Internet[/url] - the Access Dump home page where it and a variety of other tools are available to make the process easier. ----------------------- [b]Text Dump[/b] Just simply dump it as text and if you are using phpMyAdmin you can import it as long as you make sure the delimters are set. 1. Select your table 2. Go to File >> Export 3. Then in the 'Save as type' drop down scroll down to 'Text Files' and leave the 'save formatted' box unchecked. 4. Click the 'Save All' button. 5. This brings up the Export Text Wizard which gives you options and shows you the result. 6. You want to make sure the 'Delimited' radio button is checked. 7. If you want to change any options (like the delimter or the fields to be exported, etc.) it can be done by clicking the 'Advanced' - some of these (e.g. delimter) can also be set on the next page. So press Next and change those options if needed. 8. Click Next and it shows your location for the dump and you can select finish which saves the file and exists the wizard. ---------------------------- Relevant FAQs: [internallink=5568]Can I convert from ASP to PHP or from PHP to ASP?[/internallink] _________________ [internallink=4626]Emperor[/internallink] [small][i](Added by: [url=http://www.ozoneasylum.com/cgi-bin/ubbmisc.cgi?action=getbio&UserName=Emperor]Emperor [/url] on Tue 16-Mar-2004)[/i][/small] [small][i](Edited by: [url=http://www.ozoneasylum.com/cgi-bin/ubbmisc.cgi?action=getbio&UserName=Emperor]Emperor [/url] on Tue 16-Mar-2004)[/i][/small] Loading...
Options:	Enable Slimies Enable Linkwords

« Backwards — Onwards »

Show Forum Drop Down Menu