It is possible to query an Access database and export the results into a text file. 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 "Select from Access" and click the "Select from Access to Text/CSV" to add the instruction.
4. Link a database as the source [1], a text file as the target [2] and then click on "View/Edit SQL" [3] to launch the SQL editor that will allow you to define the select query.
5. Enter your query and Save.
Comments
0 comments
Please sign in to leave a comment.