Solved

extract data from access to be uploaded to oracle 11g

Posted on 2013-12-05
1
728 Views
Last Modified: 2013-12-05
Can someone recommend or clue me in as to how to extract data from an Access database to be uploaded to Oracle 11g?
0
Comment
Question by:tesla764
1 Comment
 
LVL 12

Accepted Solution

by:
pdebaets earned 500 total points
ID: 39698872
Using ODBC, you can link Oracle tables to your Access database. Then you could write an append query to copy records from your Access table to your linked Oracle table. You need to download and install the Oracle ODBC driver for Access.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question