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.
Before we get started
Please further create a ‘Manipulate a file’ or ‘Multiple file manipulations’ action step so that you can add and use instructions.
The Managed Table has the following design:
The Managed Table contains the following data:
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 an ‘Select to Access’ instruction.
2. This instruction allows 2 methods of designing the query. Like the ‘Run query’ instruction, the Expert SQL Editor can be used. Alternatively, the Query Builder can be used. The Query Builder is a simple and intuitive tool which allows users who are unfamiliar with SQL language to design queries. Click the ‘Design query’ hyperlink to open the Query Builder.
3. Double-click the name of the Table from the ‘Available Tables’ pane. The fields from this table will appear in the Query Builder under the ‘Tables to work on’ section. All the fields will be selected by default.
4. Click the ‘+’ sign to the right of ‘And’ under the ‘Define selection conditions’ section.