In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Writing output to access tables automatically

Serkan_Varol
6 - Meteoroid

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:)

1 REPLY 1
alexnajm
19 - Altair
19 - Altair

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.

Labels
Top Solution Authors