Please Help me, How can I do, to export data from Oracle7 to MSACCESS97?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Please Help me, How can I do, to export data from Oracle7 to MSACCESS97?

  1. #1
    Join Date
    Oct 2001
    Posts
    3

    Question

    Please Help me, How can I do, to export data from Oracle7 to MSACCESS97?

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712

  3. #3
    Join Date
    Apr 2001
    Location
    UK
    Posts
    137
    If you have an ODBC connection to the Oracle database, you can simply link the tables in Access and view them as if they were Access tables.

    Alternatively, you can import the tables using "File/Get External data/Import". Click on the "Files of Type" and look for the ODBC Databases() option. When you select this, the display changes completely to the select data source scereen and you can select your Oracle database from the "Machine Data Source" tab.

  4. #4
    Join Date
    Oct 2001
    Posts
    3

    I have a problem...

    My Oracle's machine isn't online, this's on another server that my MSACCESS, therefore, I think that, I will need to create a batch process.

  5. #5
    Join Date
    May 2001
    Location
    New Zealand
    Posts
    123
    Hi

    Export all the Data from the Oracle Database in delimeted
    text file and import the same using Access .

    Dirty but better than moving the same using ADO .

    Hope this Helps
    Afshin

  6. #6
    Join Date
    Oct 2001
    Posts
    3
    Are you hear talk about DTS?

  7. #7
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    If the Oracle machine is offline, what platform is it (Unix, NT, OS390, Windows?)


    Everything is worlds easier if you can put the Oracle server online.

    If the Oracle is an Microsoft OS, you could load Access on it and migrate there, then move the MDB to its permanent home.

    How much data are we talking about? Is this a one time thing, or regular?



    If your Oracle is V7.0.x or V7.1.x, some platforms (such as VMS) included a SQL*CALC app which was a spreadsheet that was designed for ORacle. You could access the tables there and put out an Excel compatible file that Access could read.

    More data is needed to give options;.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

Posting Permissions

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


Click Here to Expand Forum to Full Width