It is possible to migrate an Access database table to a SQL table. These are the steps.
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 "Access to SQL" and click the "Copy from Access to SQL table" to add the instruction.
4. Configure your instruction, select the Access database and table you want to import into the SQL table.
Tips and tricks
Remember, the structure, i.e. the number of columns and data type, in both tables must the be same.
Comments
0 comments
Please sign in to leave a comment.