Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004

    Unanswered: Import into Access

    Hi All,
    I have got a export file (.dmp) file from Oracle 9.2 database . I need to import this file into a Access 97 database. I am new to MS Access .Can anyone tell me how this could be achieved.

    Thanks in Advance

  2. #2
    Join Date
    Feb 2004
    Chicago, IL
    Sounds like it could be a text file. Do you know if it is a delimited file (commas or some other delimiter between fields) or a fixed width file (each field is a specific number of characters). You can use File/Get External Data/Link Tables to get the wizard going. Once that has started and you pick the file Access will try to determine the layout. If it can't then you will need to go to the Advanced button. There you can tell it all the details about the file. Which field is first, second, thrid etc. Then if you need to link to other files at a later date, then save the 'description' of the file as a file specification and you can reuse it without having to type in all the information again.

  3. #3
    Join Date
    Sep 2001
    If you have no better suggestions, I can suggest a roundabout way. I suggest that you download and install a free copy of Oracle onto your PC temporarily, then import to that.

    Then set up an ODBC connection to the Oracle database from your ACCESS project. You can then see the Oracle table structures and data within ACCESS.

    If you want to then dump the data to ACCESS tables, you can now manually make copies of the ORACLE table structures -- comparing the new table side-by-side with the original to ensure they are correct. Then copy the data from Oracle table to ACCESS table and finally, delete the Oracle table ODBC-links so they are no longer visible.

    Sorry I don't have a better answer. I know this works, because I've done it.

Posting Permissions

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