| | |
|
|
|
export tables from Access 2003 to a MySQL |
|---|
| message from =?Utf-8?B?ZW1wdGluZXNz?= on 27 May 2004 |
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!!!!!
|
| =?Utf-8?B?ZW1wdGluZXNz?= replied to =?Utf-8?B?ZW1wdGluZXNz?= on 27 May 2004 |
It was a firewall problem. I don't see why cause both databases are in the same PC, but now is working.
|
| Douglas J. Steele replied to =?Utf-8?B?ZW1wdGluZXNz?= on 27 May 2004 |
Do you have a primary key defined on the tables in MySQL? ODBC treats tables
as read-only unless they have one.
|
| =?Utf-8?B?ZW1wdGluZXNz?= replied to Douglas J. Steele on 27 May 2004 |
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 replied to =?Utf-8?B?ZW1wdGluZXNz?= on 27 May 2004 |
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.
|
|
Archived message: export tables from Access 2003 to a MySQL (Microsoft Access Error Message)
