It is possible to update a table in an Access database using a range in an Excel file, these are the step.
Steps
1. Create a new action step by clicking on three vertical dots (found to the right of the group's name) and then select "Add action step":
2. Under "Manipulating Data" select "Manipulate Data"
3.Click "Select Instruction Type" and search for "Excel to Access" and click the "Copy from Excel to Access" to add the instruction.
4. Configure the instruction, this includes selecting a range in an Excel file as the source and a table in the access database as the source.
Tips and tricks
Selecting "Recreate table structure?" will alter the schema of the table in the Access database to make it match with the Excel file.
Comments
0 comments
Please sign in to leave a comment.