Toad World® Forums

Automation export to MS ACCESS

Hello All,

Please can someone help me on how to export data to msaccess through automation?

Please any help will be greatly appreciated.

Thank you

Go into Automation:

Choose Export Wizard from the menu list:

Create a template:

Follow the steps in the wizard pages that come up, i.e. select your source object(s). When you get to the Output page of the wizard choose MS Access as the output. You can create a new table or use an existing table. Once you have this setup schedule the job to run and you should be good to go.

-Mark

In the Export wizard chose the export type of Access DataBase

Thank you, this is very much appreciated