Convert Access to mySQL...should be easy
I'm a pretty tech guy and after hours of searching on the web, I find it pretty frustrating that there doesn't appear to be a way to convert a MS Access DB to mySQL...for use in my JDBC application.
Several apps I downloaded didn't work and I found a VB script that reported errors that "Database" was a user-defined type.
Does anyone have a REAL way to get the structure and data from Access into mySQL?
Frustrated in Colorado.
/paul
[475 byte] By [
pcarver] at [2007-9-26 3:54:22]
Here is the solution.
I had seen on a lot of websites the "exportsql.txt" VB script. I had tried to use this, but always received a compile error...it complained that "Database" was a user-defined type. After much investigation, I found I had to turn on/off some of the other resources in the VB editor (Tools | Resources). In fact, it turned out that the Database, Index, Field, etc. VB types that were being used came from the wrong resource. Finally got things working and the script seems to do a pretty good job.
Hope this helps someone else. Just thought folks would want to know.
BTW...I'll source code control the output part that created my tables! Wouldn't want to repeat this process down the road.
This is so easy......
Convert the Access database tables into comma delimited text files. Create a table in MySQL with the correct schema for the table and then load the comma delimited file into MySQL. "Teach yourself MySQL in 21 days" has a detailed explanation on how to do this.
I had to do the same thing, it took less than an hour.
adios
