No tables when importing to access
I've done this 1000 times, but not recently, so perhaps I'm just missing something here, but...
What I normally do is create the MySQL database, create the ODBC connection for MySQL, then once the DB is populated, I import the data to access (File | Get External Data | Import | blah blah blah). Usually, once I select the database to import, Access prompts me with a list of tables in that DB, I select the table to import, and everything comes over nice and easy.
However, today I tried to import data... I used the same methods as above, but I never got prompted with a list of tables, it just took me back to the default view of Access. The DB is well established, and I've used the ODBC connection before to import data... but for some reason it's not working today.
Anyone seen anything like this before? Any thoughts?
Thanks in advance.