May 13th, 2000, 08:55 AM
Join Date: May 2000
Time spent in forums: < 1 sec
Reputation Power: 0
Hey folks, I had some major problems with this too. I tried some of the export scripts that I found around the net, but none of them worked for me.
So, I recreated each table definition (which is very useful to have now for backup) in MySQL, and then cut & paste all my old data into the new tables via Access 2000.
Here's my setup:
- win2k server
- latest MySQL (as of yesterday)
- latest MyODBC ODBC driver
- access 2000
Here's what I did:
- installed MySQL and created a db
- created the table definitions (as mentioned above... yeah it was a lot of work for the 1st few tables, but then everything was cut & paste after that)
- created an ODBC link to my new MySQL database (set it up as a System DSN as opposed to a User DSN)
- open up Access 2000, and selected FILE->OPEN. (then select the filter drop down box and select the last option ( ODBC Databases() )
- then open up your MySQL database that you just setup in ODBC
- then select all your tables to import
- then hit FILE->GET EXTERNAL DATA->Link Tables and select your original Access db that you want to migrate your data from.
- then open up one of the tables that you've linked to in your Access db, select all the records, Copy them, and paste them into the corresponding records of the MySQL table.
A lot of work ( a couple of hours ), but now all my data is over in MySQL.
I hope that helps SOMEONE! ;-)