Access to MySQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
phpScott
DevNet Resident
Posts: 1206
Joined: Wed Oct 09, 2002 6:51 pm
Location: Keele, U.K.

Access to MySQL

Post by phpScott »

I hate to have to do it but I must mention m$ here.
Of course this is also a good thing as a new project has come up and we are trying to move people form M$ access 2000 to MySql.

Here is the question.

I can't figure out how to do a proper data dump out of access into something that mysql could understand.
I can get the data but it has no table or column definitions.

Any idea how I can get access 2000 to cough up this information so I can transport it to mysql.

Thanks

phpScott
User avatar
nigma
DevNet Resident
Posts: 1094
Joined: Sat Jan 25, 2003 1:49 am

Post by nigma »

You have way more experience than me with a lot of stuff probably, so you might have already thought of this, but can you open access 2000 files in notepad or another simple text editor and view the contents of the access database in a readable and somewhat understandable format? If so you could write a perl (or PHP) script to go through the text file and then generate a mySQL file.

I don't have access so I cannot check this out myself.

Just throwing out ideas.
jason
Site Admin
Posts: 1767
Joined: Thu Apr 18, 2002 3:14 pm
Location: Montreal, CA
Contact:

Post by jason »

There are many programs that can do this for your. Just do a search on Google for Access to MySQL programs.
User avatar
nigma
DevNet Resident
Posts: 1094
Joined: Sat Jan 25, 2003 1:49 am

Post by nigma »

Jeese, you are just full of knowledge ... or is it common sense ... ;)
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Post by JayBird »

loadsa programs out there that can do it for ya, i use SQLyog.

Or you could export from Access as CSV and write a snall script to inout it into a MySQL database. Check out the code i wrote here http://www.devnetwork.net/forums/viewto ... 93&start=0 with a little simple modification, this will do the trick.

Mark
User avatar
igoy
Forum Contributor
Posts: 203
Joined: Fri May 02, 2003 11:57 pm
Location: India
Contact:

Post by igoy »

download myODBC from mysql site... create DSN for mysql database using it and export from Access to MySQL...
Unipus
Forum Contributor
Posts: 409
Joined: Tue Aug 26, 2003 2:06 pm
Location: Los Angeles, CA

Post by Unipus »

We just output a tab-delineated text file from Access.

Look how many solutions there are. It truly is a fabulous world.
User avatar
igoy
Forum Contributor
Posts: 203
Joined: Fri May 02, 2003 11:57 pm
Location: India
Contact:

Post by igoy »

indeed it is unipus...

I wish everything in this world is so fabulous and clean...
Wish for World Peace..
:)
Post Reply