The select to Access instruction allows a user to select data (via a query) in a Managed Table and copy the selected data to an Access database Table.
For the purposes of this article we are going to use a simple and fictitious Managed Table named “AirlineInfo”. You will want to replace this Table with one of your own.
The Managed Table has the following design:
And t he Managed Table contains the following data:
Before we get started, create a ‘Multiple file manipulations’ action step so that you can add instructions.
For this instruction to run successfully, the design of the Access Table must match the design of the Managed Table. That is, they must have an equal number of fields, and every field must share the same data type. The Access Table, therefore, must have the following design:
1. Create a ‘Select to Access’ instruction.
2. Link the Access database file that the data will be copied into from the managed table. By clicking on the "Link" button and then selecting the Access database which is uploaded in a data step.
3. Select the desired table from the database to copy data into.
4. Click on "View/Edit SQL". This will open up the SQL Editor in a new tab.
5. Type the desired Select statement/query into the SQL Editor. The "play" button can be clicked to preview the output of the query, which will be displayed at the bottom of the editor.
6. When you are finished save and close the editor.