• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 907
  • Last Modified:

Export an MS Access database to a MySQL database

Hi,

I'm trying to convert an MS Access 2003 database with a variety of tables and data into a MySQL database. Just need to exactly replicate it.

I CANNOT (as in am not allowed to ny my hosting company) to connect to the MySQL database remotely, so cannot use any ODBC connectivity tools to do the importing.

I can only connect to the new MySQL database via phpmyadmin so my choices here are rather limited.

0
Sean Clarke
Asked:
Sean Clarke
  • 2
  • 2
1 Solution
 
enriquecadalsoCommented:
This article explains this process using a import/export approach. I think you can do it using phpmyadmin.

http://www.kitebird.com/articles/access-migrate.html
0
 
souquetbressandCommented:
Have you attempted the above solution?  If not, I have a few other suggestions as I've migrated multiple databases to MySQL from Access.
0
 
Sean ClarkeAuthor Commented:
I bought some software to export the MS Access tables and content to SQL scripts that I've ran into the MySQL database.
0
 
souquetbressandCommented:
I believe that closing this question without assigning points is inappropriate given the inquirer did not respond to the suggestion given and thus did not give the Experts an opportunity to offer a different solution.  
0
 
Sean ClarkeAuthor Commented:
OK - I downloaded the Access 2 MySql application from http://www.convert-in.com/acc2sql.htm

Ran it to create an SQL dump from my access database.
Then logged into my MySQL database and imported the SQL that the utility had created, thus creating a copy of the access database
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now