Created a new DB last week and I want to import the data into Access. I've done this 1000 times but for some reason it's not working today. Not sure if I'm missing something as I haven't done an import in a couple of months, or if there is a problem.
I setup the ODBC connection, opened access, did the typical import steps. Normally, after you select the ODBC database, access asks which table(s) you want to import. At this point in the process, nothing happens for me... I select the database and nothing... I never get the list of tables, I just get taken back to the default view of access.
Anyone heard of anything like this? Access isn't frozen/hung or anything, I just never get a table list.