Richard Bemrose wrote:
> [Sorry if this article was poster twice - my workstation hung on me!]
> We are experiencing problem while trying to export a table from MS Access
> to MySQL using MyODBC. We can only manage to export the table 'foo' to the
> 'bar' database on our SQL if the table does not previously exist. If it
> does exist, Access reports the following error message:
> [TCX][MyODBC] Table 'foo' already exists [#1050]
> Any help/clues would be appreciated. Summary to follow.
I have exported Access tables only once.
Then I changed their contents by linking the mysql tables into Access.
This assumes, that you can use a connection to mysql while changing data.
If you cant use this way, just drop the table in mysql before exporting it from Access.