Solved

Copying Access tables to Oracle

Posted on 2009-04-09
1
255 Views
Last Modified: 2013-12-19
We have several Access databases and we need to copy the tables over to Oracle. What would be the best way to copy these tables over?  I need the table names, fields, data type  and data intact once it moves.  Another word, a mirror image of tables in access in oracle.

Thanks In advance

pandkyon
Psuedo code:
 

connect to oracle db via odbc (login / password)

connect to Access DB and read each table

copy table to Oracle

loop through until all tables are coped to Oracle

close connection 1

close connection 2

Open in new window

0
Comment
Question by:pandkyon
1 Comment
 
LVL 9

Accepted Solution

by:
Deathrace earned 500 total points
ID: 24109277
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This video shows how to recover a database from a user managed backup
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

914 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now