Using ADO to import Access table

D

dksaluki

Is anyone familiar with ADO? I'm trying to import a tables that are
in an Access database file. I can import every table except a
particular table named "DataBase". Now when I go into Access and
change the name of that table, then go back to Excel to import it, it
works just fine. So what is it about the name "DataBase" that Excel
does not like?! Any help would be greatly appreciated.
 
M

Mark Ivey

Not totally sure, but it may be a command word that cannot be used properly
in your code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Table Security in Access 2013 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
List all tables, including document structure 0
export excel data to access table using ADO 0
Access Lock File .LACCDB / Now shows as a notepad file 0
importing Access via code 0
SQL data from VBA - Sort into groups via heading. 7

Top