a touch question about exporting M.S.Access to MySQL

[mimosa]

hi,

i am trying to export some M.S.Access databases to MySQL,

MySQL version: mysql-shareware-3.22.34-win.zip
MyODBC version: myodbc-2_50_19-nt.zip
ACCESS of OFFICE 2000.

I installed the MySQL server and ACCESS both in my own machine, windows 2000. now I can import MySQL databases to M.S. Access smoothly, but when I try to export M.S.Access data to MySQL,

error: ODBC call failed
[Microsoft][ODBC driver manager(#0)

what's wrong with that? any suggestions should be greatly appreciated.

 

[devnull22]

Hi mimosa,
You could always export the Access db to a text file.
Then import it to MySQL.

The import command is .

mysql>LOAD DATA LOCAL INFILE '/path/to/db.txt'
INTO TABLE table_name
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';


for fields terminated by tab use '\t'

hope this helps
Refer to the mysql manual for further info.

Cheers

 

[rycamor]

Even easier, on the MySQL website there is page of links to third-party software and utilities. One of these is ExportSQL, an Access module (script) to dump a complete Access database to mysql-readable SQL script. It handles table creation, type conversion (mostly), primary keys, the works.

http://www.cynergi.net/exportsql/

I've used it myself once and it worked beautifully, needing only one small tweak to the SQL output before running in MySQL.

 

[Guest_imported]

i use to myself todo just "that" (do export from the file menu of access) but now after i upgraded my odbc driver with the newest myodbc , i cant do it anymore, and i get the same error, what a bummer it was so cool to export tables that way...

 

[Guest_imported]

Even easier (he says after much searching)

Go to the contributor downloads page of mysql.com
Under Working with other programs
You will find MyAccess -
Use the link to MyAccess homepage (to get the latest version)
Download 1.4 (or later if there is a later release)for Access 2000. Make sure its the right version, Access97 isn't the same as you have no doubt descovered.

PS I don't think ExportSQL works with Access2k.

 

[rozek]

hi,
i am trying to export some M.S.Access databases to MySQL,
MySQL version: mysql-shareware-3.22.32 for linux
MyODBC version: myodbc-2_50_36-win95
ACCESS of OFFICE 2000.
I've installed the MySQL server on a remote machine and MS Access in my own machine, windows 98.I can import MySQL databases to M.S. Access smoothly, but when I try to export M.S.Access data to a remote MySQL server,
error: ODBC call failed
[Microsoft][ODBC driver manager(#0)
what's wrong with that? any suggestions should be greatly appreciated.