RyanD789
Fri 26th Jul '02, 8:06pm
I am going to kill myself. This problem is driving me CRAZY!
I would like to export Access 2000 data to MySQL. Using MyODBC, I did it! Now, since some data changed in my Access DB, I want to update the MySQL database with the new info. When I export it again, it says: Table Already Exists.
Do I have to manually Drop the database from MySQL before updating it every time???
Is there a way to link an existing Access table (which will be updated in Access very often by OTHER programs) and MySQL, so that MySQL always has the updated information? I can't seem to figure it out. I can link the Access table to MySQL, but not MySQL to Access.
Please help! There are some really smart people on this board. The other MySQL boards suck compared to the people on this one.
Thanks!
Ryan
I would like to export Access 2000 data to MySQL. Using MyODBC, I did it! Now, since some data changed in my Access DB, I want to update the MySQL database with the new info. When I export it again, it says: Table Already Exists.
Do I have to manually Drop the database from MySQL before updating it every time???
Is there a way to link an existing Access table (which will be updated in Access very often by OTHER programs) and MySQL, so that MySQL always has the updated information? I can't seem to figure it out. I can link the Access table to MySQL, but not MySQL to Access.
Please help! There are some really smart people on this board. The other MySQL boards suck compared to the people on this one.
Thanks!
Ryan