Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    294

    Lightbulb Unanswered: Oracle with MS Access

    Hello, I'm trying to create a connection of my Oracle db with ms access, so I want to read some access tables from my oracle user, using an odbc connection and a dblink, I dont have information about It, can you explain me the process step by step or can you give me a document to do It ??

    I used to do It with a fox pro database, and now I don't know how to repeat the process with access.

    Thanks !!!

  2. #2
    Join Date
    Dec 2003
    Posts
    148
    Set up a system DSN for the oracle DB.
    open a blank access db...
    Select get external data from the file menu > link tables > select the dsn you made for your oracle Db

  3. #3
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    You should also do a Google search for "heterogenous services Oracle". First article that comes up is very easy to follow. Or simply click here: Heterogeneous Services

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •