MySQL Forums
Forum List  »  Microsoft Access

No tables when importing to access
Posted by: Jackson Taylor
Date: August 09, 2005 11:41AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
No tables when importing to access
2641
August 09, 2005 11:41AM
1810
jmg
August 19, 2005 02:45AM
1835
August 23, 2005 07:48AM
1801
September 06, 2005 11:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.