# Automation export to MS ACCESS

**URL:** <https://forums.toadworld.com/t/automation-export-to-ms-access/40615>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [February 20, 2018, 11:19am UTC](https://forums.toadworld.com/t/automation-export-to-ms-access/40615 "2018-02-20T11:19:58Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Zentel1](https://avatars.discourse-cdn.com/v4/letter/z/ed8c4c/32.png) [@Zentel1](https://forums.toadworld.com/u/Zentel1)\
**Post date:** [February 20, 2018, 11:19am UTC](https://forums.toadworld.com/t/automation-export-to-ms-access/40615/1 "2018-02-20T11:19:58Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Mark\_Kurtz](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mark_kurtz/32/10_2.png) [@Mark\_Kurtz](https://forums.toadworld.com/u/Mark_Kurtz)\
**Post date:** [February 20, 2018, 12:01pm UTC](https://forums.toadworld.com/t/automation-export-to-ms-access/40615/2 "2018-02-20T12:01:46Z")

</div>

Go into Automation:

 ![tdp-access1.png](https://global.discourse-cdn.com/quest/original/2X/3/3c505ca9f4e540d6c23468b757275bc25131dd87.png)

Choose Export Wizard from the menu list:

 ![tdp-access2.png](https://global.discourse-cdn.com/quest/original/2X/3/3b0845b93a3d0d7840c905dd426748173dfec79f.png)

Create a template:

 ![tdp-access3.png](https://global.discourse-cdn.com/quest/original/2X/3/37888ed9abbe287f5a0ebd92868c727efcbda171.png)

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

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [February 20, 2018, 3:01pm UTC](https://forums.toadworld.com/t/automation-export-to-ms-access/40615/3 "2018-02-20T15:01:15Z")

</div>

In the Export wizard chose the export type of Access DataBase

 ![export access.png](https://global.discourse-cdn.com/quest/original/2X/9/94a24fa4071ac3c8141987d65e52daae9142dc49.png)

---

<div class="post-metadata">

**Author:** ![Zentel1](https://avatars.discourse-cdn.com/v4/letter/z/ed8c4c/32.png) [@Zentel1](https://forums.toadworld.com/u/Zentel1)\
**Post date:** [February 20, 2018, 5:51pm UTC](https://forums.toadworld.com/t/automation-export-to-ms-access/40615/4 "2018-02-20T17:51:04Z")

</div>

Thank you, this is very much appreciated