OraDump-to-Access is a program to export data from Oracle dump files into Microsoft Access databases. The program does direct reading from the dump, so Oracle installation is not required. Command line support allows to script, automate and schedule the conversion process.

Features All versions of Oracle dump files are supported (both EXP and EXPDP) Exports data into MS Access 97/2000/2010/2013 Encrypted dump files are supported Option to merge Oracle data into an existing MS Access database Option to convert individual tables Converts parallel export Oracle dump files Stores conversion settings into profile Command line support Quick Launch Easy-to-use wizard-style interface Full install/uninstall support The product can be customized according to customer requirements Unlimited 24/7 support service 1-year subscription for updates Limitations Does not support compressed dump files Does not convert foreign keys Does not convert stored procedures Does not convert columns having user-defined types Demo version converts only 50 records per table

Requirements

• Supported OS: Windows XP(SP2 or SP3)/Vista/7/8/10, Server 2003/2008/2012/2016, Linux with WINE
• Microsoft Access/Office or Access Runtime installation

Quick Launch

Once you stored conversion settings into profile you can run the program in Quick Launch mode. Just launch Windows Explorer and double-click on the profile description file (.od2a) with left mouse button. This will cause OraDump-to-Access launch conversion loading the necessary settings from the specified profile. Then you will be taken right to the screen with progress of conversion without entering all conversion settings.

How to process parallel export Oracle dump files

To speed up exporting data into dump Oracle allows export operation to be executed by multiple threads that are working at the same time. Each thread generates output in its own file, so the result of the parallel export job is a set of files. OraDump-to-Access can extract data from the first file of that set only. To read the entire data it is necessary to merge all files of parallel export into the single one with ormerge.exe tool that can be found in the installation folder. It is a console utility that accepts the following arguments:

ordmerge.exe <dumpfile#1> <dumpfile#2> ... <dumpfile#N> <resulting file>

Then OraDump-to-Access should be run against the resulting file.

Try before you buy

Still not sure the program fits your needs? Try free demo version with limited features. It will allow you to convert only 50 records for each database table. Test the quality of the demo and come back to place an order if satisfied with the results.