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?
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.