Automation export to MS ACCESS

Toad Data Point
1

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

2

Go into Automation:

tdp-access1.png
tdp-access1.png3112×203 112 KB

Choose Export Wizard from the menu list:

tdp-access2.png
tdp-access2.png541×1112 145 KB

Create a template:

tdp-access3.png
tdp-access3.png1562×406 69.2 KB

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

3

In the Export wizard chose the export type of Access DataBase

export access.png
export access.png1133×687 27.3 KB

4

Thank you, this is very much appreciated