# Exporting to Access

**URL:** <https://forums.toadworld.com/t/exporting-to-access/6189>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [April 14, 2010, 4:08pm UTC](https://forums.toadworld.com/t/exporting-to-access/6189 "2010-04-14T16:08:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![MattS](https://avatars.discourse-cdn.com/v4/letter/m/8e8cbc/32.png) [@MattS](https://forums.toadworld.com/u/MattS)\
**Post date:** [April 14, 2010, 4:08pm UTC](https://forums.toadworld.com/t/exporting-to-access/6189/1 "2010-04-14T16:08:45Z")

</div>

Hi

I have a quick question about exporting data to Access.

I am aware that TDA allows for exporting to a new Access file. However, in my current version of Toad for Oracle, one of the features that has proven useful is an export to existing Access databases, either adding new tables to the database, overwriting existing tables, or appending data to an existing table.

I’ve had some success using heterogeneous queries to accomplish this, but I’d much prefer to be able to use the native provider for the queries. Is there any chance this option might be in the works?

Thanks,

Matt

---

<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:** [April 14, 2010, 4:17pm UTC](https://forums.toadworld.com/t/exporting-to-access/6189/2 "2010-04-14T16:17:11Z")

</div>

Absolutely. We have the following items on the ‘to-do list’.

1. Exporting a new table to existing access file.
2. Appending to existing access table.
3. Truncating then appending to existing access table.

Debbie