Question:

Is there an easy way to convert an MS Access DB to an Oracle DB?

by  |  earlier

0 LIKES UnLike

my company is changing to use Oracle from Access, Is there a way to run a report in Access, and then convert it to be uploaded into Oracle or converted to Oracle?

 Tags:

   Report

2 ANSWERS


  1. To convert MS Access DB to Oracle DB:

    Click "Edit" then "Find and Replace", then replace "MS Access" with "Oracle."


  2. Oracle should be able to import .CSV (Comma Seperated Values)files.  Export your Data or Tables in .CSV  format and Oracle should be able to pick it up.

    As for a direct & complete conversion, No.  Microsoft has software that converts MS ACCESS into SQL SERVER, but since ORACLE is a COMPLETELY different company...

Question Stats

Latest activity: earlier.
This question has 2 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.