asked on
Using MySQL ODBC to Overwrite a table.
Hi, I have a table that I have exported to an MySQL database sucessfully using the ODBC connector. Works like a dream.
Now that I have exported it, I have made changes in access and I want to update it again.
When I use the same procedure that I used to export it, It tells me it caznt becasue that table already exists.
How can I tell Access that it is okay to overwrite it?
Please advise. --JM
Now that I have exported it, I have made changes in access and I want to update it again.
When I use the same procedure that I used to export it, It tells me it caznt becasue that table already exists.
How can I tell Access that it is okay to overwrite it?
Please advise. --JM
Microsoft AccessMySQL ServerDatabases
Last Comment
Cedric Obinna A.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
If you really want to overwrite, then open mysql\data folder and open the folder with the name of your database. DELETE three files tablename.myi, tablename.frm, tablename.myd. That gets rid of the table completely. Then DO THE EXPORT AGAIN.