Update "Select" Record in Access Table via Excel Input

Question

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

unknown · Accepted Answer

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.