Hello,
I want export my table from access to mysql by button click.
Here my code:
DoCmd.TransferDatabase acExport, "ODBC Database", _
"ODBC;DSN=bw base to mysql BannyworksDB;UID=###;PWD=###;LANGUAGE=us_english;" _
& "DATABASE=BannyworksDB", acTable, "bazaT", "bazaT"
It is fine work, but if I click button again shortly it put out error:
Table already exists (#1050)
Furthermore I set in ODBC driver settings Ininitial Statement: DROP TABLE IF EXISTS `bazaT`;
Any help?
Please
I want export my table from access to mysql by button click.
Here my code:
DoCmd.TransferDatabase acExport, "ODBC Database", _
"ODBC;DSN=bw base to mysql BannyworksDB;UID=###;PWD=###;LANGUAGE=us_english;" _
& "DATABASE=BannyworksDB", acTable, "bazaT", "bazaT"
It is fine work, but if I click button again shortly it put out error:
Table already exists (#1050)
Furthermore I set in ODBC driver settings Ininitial Statement: DROP TABLE IF EXISTS `bazaT`;
Any help?
Please