Return
-
Title
Toad for Data Analysts. How to schedule an automation exporting data to an Access database and ap -
Description
Toad for Data Analysts. How to automate exporting data to an Access database and append the new results in the same table? How to schedule it as well?
-
Resolution
Go to Tools menu | Automation | chose “Export Wizard” | selected a table | chose “Access Database File” | chose “Single New Table” (do not check-mark “Drop and recreate if exist”) | finish the Automation Wizard.
To schedule it, click on the “Schedule” button | set it to run on your preferred times. These steps will append new data to the same table and database.