How to automate exporting Access queries to Excel
As a simple example we'll export a query from an Access database to an existing Excel file.
| 1. In the main window click the '+' button: |  |
| 2. In the new task window click the '+' button under the 'Actions' tab: |  |
| 3. In the new action window click the top dropdown and select 'Transfer Access data to Excel': |  |
| 4. Enter the Access database path, the query name or the SQL, the target Excel workbook (for new one add a new name), the sheet name and the target range. For new sheets enter a new name. Named ranges are also supported. |
 |
| 5. Once returned to the new task window click the 'Add task' / 'Update task' button |  |
| 6. To run the transfer click the '►' button. |  |
| 6. The data is now in the Excel file. |  |
And that's it!
For more advanced tasks and automatic (time or event based) scheduling please see other sections of the how-to guide.