ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using ADO to import Access table (https://www.excelbanter.com/excel-programming/403615-using-ado-import-access-table.html)

dksaluki

Using ADO to import Access table
 
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.


Mark Ivey

Using ADO to import Access table
 
Not totally sure, but it may be a command word that cannot be used properly
in your code.



"dksaluki" wrote in message
...
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.



All times are GMT +1. The time now is 02:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com