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.
This is possible to do using the export wizard. Connect to your Oracle database, and select Tools->Export->Export Wizard to begin the wizard.
Click next to go past the welcome screen, and you’ll have an option to add objects to export
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.
Click next to choose the destination type and select Access and click next
Choose your columns to export and click next
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
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.
Click next to execute the template.
Please let me know if you have any additional questions or concerns.
Thank you Mike.