I managed something similar to this once before but now I can't make it work again.
I want to export some Access database tables to mySql. I am trying to use ODBC. It's all installed and set up in my Windows machine (Vmware). In the "ODBC Data Source Administrator" the connection I have set up to the mySql database tests OK.
However when I try to Export from my Access database I get a pop up box saying:-
[MySQL][ODBC 3.51 Driver]User cancelled
A Google search for this error doesn't reveal much of help. I've tried turning on the logging for the ODBC connection and I'm none the wiser really.
What I can't really understand is that when I do the export it doesn't allow me to select the database to export to, how can it do an export of a table without knowing the database name? If I click on the Database pull-down in the export configuration it says "Loading database list not implemented for SQLDriverConnect()".
Any ideas anyone?