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
Access to MySQL
Moderator: General Moderators
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.
I don't have access so I cannot check this out myself.
Just throwing out ideas.
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
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