SOLVED
Dynamic Input with Access Database - How to Chose the Table?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Deliverance
7 - Meteor
‎05-26-2021
12:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all, I'm trying to use the Dynamic Input tool for an Access db but I'm not sure how to indicate the table name similar to how you'd add a sheet name if inputting from excel. Is there a way to do this for an Access db? I'm getting the same error as if you didn't indicate a sheet name when using excel: "No table chosen; Please select a Table from data source.
Solved! Go to Solution.
Labels:
2 REPLIES 2
MattBSlalom
11 - Bolide
‎05-26-2021
02:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
An Access table uses the same format as an Excel sheet. The format is <FilePath>|||<TableName>
For example:
C:\TEMP\Database1.mdb|||Table1
apathetichell
19 - Altair
‎05-26-2021
02:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think for .accdb files you need to follow these instructions to get your system objects/a.k.a. list of tables to be visible:
then you need to have your batch macro read in each table:
