Help with MyODBC & MySQL

Hi folks. I'm a newbie at online databases & I'm having problems. I've got MyODBC installed on my PC and my hosting company has MySQL installed on their server.

I have an access database that I want to export from. However, when I try and do this all I get is "ODBC - Call Failed
[Microsoft] [ODBC Driver Manager (#0)
" in Access.

I'm using Win2K Professional & Access 2000.

Any ideas what's up and how I can solve it? It's driving me mad!

Regards,

Kevin

Kevin,
I'm having the same problem. Although I was able to import from mySQL into Access. Did you find a solution ?

I'm having the same problem! With Win98 & Access 2000 I can import but not export tables.

Well, I am having the same problem.
I know this message doesn't help, but if anyone finds a solution. HELP.

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! ;-)

//stevek