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

How to export table from outlook into ms access table? 0
ADO from Excel to Access 4
import Excel worksheet to SQL Server table 7
Access Import & Link section grayed out MS Access 2010 1
Access Importing csv daily files into access 2007 1
Excel connect/import Access data using ADO and VBA? 4
Link, drop link, relink 2
SQL data from VBA - Sort into groups via heading. 7

Top