SOLVED
Writing output to access tables automatically
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
Serkan_Varol
6 - Meteoroid
‎04-27-2024
08:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I have a workflow that I run 10-12 times a day. I want this workflow to write in this into an existing database - .accdb (on my desktop) inside different table names. I do want to change the table name each time I run the workflow (just want to hit the "run" button).
I have pretty much everything automated except that part. Any help is appreciated:)
Solved! Go to Solution.
Labels:
1 REPLY 1
18 - Pollux
‎04-29-2024
05:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You should be able to use a Formula tool just before the end to create this new table name, then "Take File/Table Name from Field" from the bottom of your Output Data tool to write to that newly created table name! I haven't done it with Access, but it works well with other output methods.
