export tables from Access 2003 to a MySQL

[emptiness]

I am trying to export tables from Access 2003 to a MySQL database. I created an ODBC with the ODBC 3.51 that I found in the MySQL's site. The ODBC is working fine, when I tested from the control panel it conects to the database. Then I go to Access, select a table then export. In the combo "Save as type" I select "ODBC Database" and select the ODBC that I created (and tested) for MySQL. I get the following error: "ODBC Falló la llamada" (ODBC: The call failed)

I am really needing to get this working as soon as posible... please HELP ME!!!!!

 

[Douglas J. Steele]

Do you have a primary key defined on the tables in MySQL? ODBC treats tables
as read-only unless they have one.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I am trying to export tables from Access 2003 to a MySQL database. I

created an ODBC with the ODBC 3.51 that I found in the MySQL's site. The
ODBC is working fine, when I tested from the control panel it conects to the
database. Then I go to Access, select a table then export. In the combo
"Save as type" I select "ODBC Database" and select the ODBC that I created
(and tested) for MySQL. I get the following error: "ODBC Falló la llamada"
(ODBC: The call failed).

I am really needing to get this working as soon as posible... please HELP

ME!!!!!

 

[emptiness]

I don't have any tables in MySQL, I want to export the Access tables to that database, but the ODBC fails when Access call it. Any idea?

 

[Albert D. Kallal]

You have to create the table in MySql first BEFORE you export.

ms-access does not know how to create a oracle table, or even a table from
Microsoft's own sql server.

Every server, or database system has it's own way to create tables.

So, create the table on the server first.

Then, link to the table in ms-access. You then use a append query to copy
the data from one table to another.

 

[emptiness]

It was a firewall problem. I don't see why cause both databases are in the same PC, but now is working.