# How can I export multiple tables into one msaccess.accdb file?

**URL:** <https://forums.toadworld.com/t/how-can-i-export-multiple-tables-into-one-msaccess-accdb-file/7359>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [July 26, 2012, 4:02pm UTC](https://forums.toadworld.com/t/how-can-i-export-multiple-tables-into-one-msaccess-accdb-file/7359 "2012-07-26T16:02:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Devi](https://avatars.discourse-cdn.com/v4/letter/d/ee59a6/32.png) [@Devi](https://forums.toadworld.com/u/Devi)\
**Post date:** [July 26, 2012, 4:02pm UTC](https://forums.toadworld.com/t/how-can-i-export-multiple-tables-into-one-msaccess-accdb-file/7359/1 "2012-07-26T16:02:00Z")

</div>

I can able to export multiple tables into multiple msaccess files but I would like to export multiple oracle tables to single msaccess.accdb file. If anyone know the answer please advise.

---

<div class="post-metadata">

**Author:** ![MikeWilson](https://avatars.discourse-cdn.com/v4/letter/m/a698b9/32.png) [@MikeWilson](https://forums.toadworld.com/u/MikeWilson)\
**Post date:** [July 26, 2012, 5:54pm UTC](https://forums.toadworld.com/t/how-can-i-export-multiple-tables-into-one-msaccess-accdb-file/7359/2 "2012-07-26T17:54:14Z")

</div>

Hi Devi,

This is possible to do using the export wizard. Connect to your Oracle database, and select Tools-\>Export-\>Export Wizard to begin the wizard.

1. Click next to go past the welcome screen, and you’ll have an option to add objects to export

2. click on “Add” and select the first table from your Oracle connection, but when doing this make sure you only select one table at a time.

3. Click next to choose the destination type and select Access and click next

4. Choose your columns to export and click next

5. Choose the .accdb file to export to, and you’ll have an option to use either an existing table, or to create a new table. Click on create new table, give it a name, and click next

6. Now you will be back at the same screen as Step 2. Repeat steps 2-5, making sure to only select one table at a time. You can select the same .accdb file for each step.

7. Click next to execute the template.

Please let me know if you have any additional questions or concerns.

Thanks,  
Mike

---

<div class="post-metadata">

**Author:** ![Devi](https://avatars.discourse-cdn.com/v4/letter/d/ee59a6/32.png) [@Devi](https://forums.toadworld.com/u/Devi)\
**Post date:** [July 31, 2012, 1:28pm UTC](https://forums.toadworld.com/t/how-can-i-export-multiple-tables-into-one-msaccess-accdb-file/7359/3 "2012-07-31T13:28:49Z")

</div>

Thank you Mike.