Page 1 of 1

Access to MySQL

Posted: Mon Aug 18, 2003 3:48 pm
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

Posted: Mon Aug 18, 2003 3:52 pm
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.

Posted: Mon Aug 18, 2003 3:55 pm
by jason
There are many programs that can do this for your. Just do a search on Google for Access to MySQL programs.

Posted: Mon Aug 18, 2003 3:58 pm
by nigma
Jeese, you are just full of knowledge ... or is it common sense ... ;)

Posted: Mon Aug 18, 2003 4:06 pm
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

Posted: Thu Sep 18, 2003 3:27 am
by igoy
download myODBC from mysql site... create DSN for mysql database using it and export from Access to MySQL...

Posted: Thu Sep 18, 2003 12:18 pm
by Unipus
We just output a tab-delineated text file from Access.

Look how many solutions there are. It truly is a fabulous world.

Posted: Fri Sep 19, 2003 3:07 am
by igoy
indeed it is unipus...

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