SOLVED
Update "Select" Record in Access Table via Excel Input
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
kheuer
8 - Asteroid
‎11-14-2017
11:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I have an Access database that contains all master data for a specific process. I receive updates on individual records via an Excel file and would like to develop a workflow that updates the Access table with only the records listed in the Excel. Ideally I would like to replace the entire record line in Access with the new Excel record via the primary key.
I look forward to any solutions you may have!
Thanks much,
Kristina
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
- Input
- Output
1 REPLY 1

Inactive User
Not applicable
‎11-14-2017
03:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can delete and re-create or append based on the standard outputs. With that said, you can take the access DB as an input and do you CDC logic within the workflow. Then re-create the Access DB.
