Hello,
[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.
Regards,
Rich
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\
/_/ Richard A Bemrose /_\ Polymers and Colloids Group \_\
/_/ email: rb237@stripped /_\ Cavendish Laboratory \_\
/_/ Tel: +44 (0)1223 337 267 /_\ University of Cambridge \_\
/_/ Fax: +44 (0)1223 337 000 /_\ Madingley Road \_\
/_/ Mobile: +44 (0)410 168 873 / \ Cambridge, CB3 0HE, UK \_\
/_/_/_/_/_/_/ http://www.poco.phy.cam.ac.uk/~rb237 \_\_\_\_\_\_\_\
"Life is everything and nothing all at once"
-- Billy Corgan, Smashing Pumpkins