If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Converting Access DB to MySQL

rymus · 2004-04-28 19:10:47

As the subject says, I'm looking for an easy way to convert a couple of MS access databases to mysql. I tried exporting tables to comma delimited text files from access but theres just nothing happening when I try to import the data through phpmyadmin. I downloaded a couple of apps that did the trick but they were limited…

Options

28-04-2004 8:10pm

#1

rymus

Registered Users Posts: 8,819 ✭✭✭

Join Date: May 2001

Posts: 8512

As the subject says, I'm looking for an easy way to convert a couple of MS access databases to mysql. I tried exporting tables to comma delimited text files from access but theres just nothing happening when I try to import the data through phpmyadmin.

I downloaded a couple of apps that did the trick but they were limited shareware and I don't see the point in paying for software that I'm going to use once.

How can I get this done as painlessly as possible?

0

Comments

Options
#2 29-04-2004 11:23pm
Dun

Registered Users Posts: 1,967 ✭✭✭

Join Date: May 2001

Posts: 1891

Install MyODBC and then export it from Access. Usually works a treat.

0
Options
#3 29-04-2004 11:44pm
rymus

Registered Users Posts: 8,819 ✭✭✭

Join Date: May 2001

Posts: 8512

I actually did it today.. Had another session on google and found a program called Navicat that did it with little trouble.. cheers for the reply Dun

0