Results 1 to 4 of 4
  1. #1
    indira is offline Novice
    Windows 7 Access 97
    Join Date
    Nov 2010
    Posts
    6

    Importing data from Oracle to access

    Hi All,



    Does anyone know how data is imported into Access from Oracle via the Noetix client? It would be very helpful to get information on this.

    Thanks,
    Indira

  2. #2
    jvstein is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    2
    I don't know the capabilities of Access '97 and don't have a copy to test. I have done something similar using older versions of Access.

    You should be able to set up an ODBC connection to either the Oracle database (to query the Noetix views directly) or using the Noetix ODBC driver (assuming you're using Noetix Platform).

    --Jeff

  3. #3
    indira is offline Novice
    Windows 7 Access 97
    Join Date
    Nov 2010
    Posts
    6
    I have downloaded something called the Discover application, but not sure how to connect it still. Thanks for helping.

  4. #4
    jvstein is offline Novice
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    2
    I'm not familiar with that tool.

    Have you tried setting up a linked table to your Oracle database? These instructions detail the process pretty well.
    http://www.aspfree.com/c/a/Microsoft...ess-with-ODBC/

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Oracle CLOB not accessible in ACCESS
    By saccitylocal in forum Import/Export Data
    Replies: 0
    Last Post: 08-31-2010, 10:29 AM
  2. Replies: 5
    Last Post: 06-24-2010, 08:00 AM
  3. Replies: 2
    Last Post: 04-22-2010, 10:40 AM
  4. iMPORTING DATA FROM EXCEL TO ACCESS
    By Rameez in forum Import/Export Data
    Replies: 7
    Last Post: 06-16-2009, 12:05 PM
  5. Oracle Discoverer to MS Access
    By money_213 in forum Import/Export Data
    Replies: 0
    Last Post: 06-27-2006, 12:43 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums