Gossamer Forum
Home : General : Databases and SQL :

convert access to mysql

Quote Reply
convert access to mysql
Please suggest a free and easy to use tool to convert access db to mysql.

Thanks,

bob
Quote Reply
Re: [bob c3] convert access to mysql In reply to
I uninstalled Access so can't be certain I'm telling you the right thing here.

Just export your access db into a delimited file and then you can use mysqlman to import the data into your mysql database.

Last edited by:

Paul: Dec 19, 2002, 11:27 AM
Quote Reply
Re: [Paul] convert access to mysql In reply to
Paul, I am on the road and my laptop does not have access. Any other way i can export as tab delimited?

I found a mdb to mysql converter online but i am having trouble doing the conversion. The access db is on my hard drive. I have attached an image of the dialog box i get to when i chose to convert the the mdb. I have no clue how to fill in these boxes and I am wondering if you will help me out. Would greatly appreciate it.

bob
Quote Reply
Re: [bob c3] convert access to mysql In reply to
Google has a wealth of info on this topic:

http://www.google.com/...;start=0&start=0

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] convert access to mysql In reply to
How do i find out what port mysql is running on?

thanks,

bob
Quote Reply
Re: [bob c3] convert access to mysql In reply to
Standard port is 3306 - it's likely this is the right one.
Quote Reply
Re: [Paul] convert access to mysql In reply to
You are right. I ran mysqladmin -p variables via SSH and confirmed that. I am certain that i am using the correct username and password for this db but i am not able to access it via either of two conversion tools. Any ideas why that would be?



\bob
Quote Reply
Re: [bob c3] convert access to mysql In reply to
Figured out that % wildcard had to be enabled on the mysql server. All is well now.



bob
Quote Reply
Re: [Alex] convert access to mysql In reply to
Heh, this thread is now the number one result for that search. =)

Cheers,

Alex
--
Gossamer Threads Inc.