Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Loading Oracle Tables into MsAccess.......

Posted on 2004-08-14
4
Medium Priority
?
130 Views
Last Modified: 2010-05-02
Hi Everybody,

    Can anybody please assist me in doing the following.
 
    I have oracle Database on one end and Ms access database on the other end.   I need to get few tables of Oracle database into Ms Access database.  
1.  How to establish connection to oracle database using Ms Access coding and How to load the similar structure tables MS access using Access backend coding.

Regards,
Sridhar.
0
Comment
Question by:sridhar_pamidi
1 Comment
 
LVL 12

Accepted Solution

by:
Bob Lamberson earned 200 total points
ID: 11803029
Hi ,
this should get you started.
http://www.orafaq.com/faqodbc.htm#ACCESSATTCH

Bob
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses

782 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