create mdb file from oracle table (automated process)

Monika08

Junior Member
Nov 11, 2011
2
0
0
Hello,
I need to create an mdb file from oracle data and I need to automate this process. I. there any way to code it through ?unix or pl/sql
 

EagleKeeper

Discussion Club Moderator<br>Elite Member
Staff member
Oct 30, 2000
42,589
5
0
Good for a one shot deal:
Link

2 seconds to google :colbert:

Otherwise you will have to find another tool and activate it from a script.
Again, there are tools out there that will handle the export

Example:
Excel-DB supports interfaces with Oracle and Access
 

Evadman

Administrator Emeritus<br>Elite Member
Feb 18, 2001
30,990
5
81
1. Create empty mdb with access.
2. Store empty mdb file somewhere oracle can access
3. oracle creates copy of mdb.
4. oracle loads copy of mdb.