Convert MS Access database to MySQL

[AdonaiEchad]

Is there any free software that will convert MS Access database to a MySQL database? Is this possible?

Thank you,
AdonaiEchad

[MarkG75]

I use a piece of software called MyAccess

http://www.hiden.org/myaccess/

[David Powers]

Post by AdonaiEchad
Is there any free software that will convert MS Access database to a MySQL database? Is this possible?

If you do a Google search for "convert access to mysql", you'll come up
with a lot of options. The method that I use requires no software other
than Access and MySQL. Export the Access database as a CSV file. Then
use LOAD DATA INFILE to import it to MySQL:

http://dev.mysql.com/doc/refman/5.0/en/load-data.html

If you use phpMyAdmin, it automates the whole process. Just select the
Import tab and select the appropriate options for importing a CSV file.

[AdonaiEchad]

What are the steps to convert access database as a CSV file. I have access 2003.


AdonaiEchad

[Murray *ACE*]

Look under Access' FILE | Save As options?
--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

Post by AdonaiEchad
What are the steps to convert access database as a CSV file. I have access 2003.
AdonaiEchad

[David Powers]

Post by AdonaiEchad
What are the steps to convert access database as a CSV file. I have access 2003.

I don't have Access installed on this machine, so I can't check, but
it's either what Murray suggests or File > Export.

Why not try the Access Help menu?

[Murray *ACE*]

It's FILE | Export > CSV....
--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

Post by AdonaiEchad
What are the steps to convert access database as a CSV file. I have access 2003.

I don't have Access installed on this machine, so I can't check, but it's
either what Murray suggests or File > Export.
Why not try the Access Help menu?
--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

[zerof]

Post by AdonaiEchad
Is there any free software that will convert MS Access database to a MySQL database? Is this possible?
Thank you,
AdonaiEchad

------
DBManager

http://www.dbtools.com.br/EN/downloads/
-----
zerof

[m***@monitor.wc.lt]

Yes ,there is! Using this http://excel2sql.esy.es/acc2sql.php Online converter , you can paste your ms Access table and receive SQL insert script to import in database. Hope it helps !

[m***@monitor.wc.lt]

Post by AdonaiEchad
Is there any free software that will convert MS Access database to a MySQL database? Is this possible?
Thank you,
AdonaiEchad

Yes ,there is! Using this http://excel2mysql.esy.es/acc2sql.php Online converter , you can paste your ms Access table and receive SQL insert script to import in database. Hope it helps !