How to transfer data from Oracle 8i to MS Access
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to transfer data from Oracle 8i to MS Access

  1. #1
    Join Date
    Dec 2002
    Location
    North Potomac, Maryland
    Posts
    1

    Question How to transfer data from Oracle 8i to MS Access

    Does anybody can let me know how to transfer data from Oracle 8i to MS Access 2000 or viceversa.

  2. #2
    Join Date
    Dec 2002
    Posts
    2

    Oracle to Access Copy

    Create a Link from your Access Database to your Oracle Database

    Enter something like this to copy data from the Oracle Database to
    an Access Table.

    This is an example from a Death Database I work with.


    SELECT * INTO
    FROM H72DEATH_H72DEATH
    WHERE ((([H72DEATH_H72DEATH].[DEATH_BOOK_YEAR])=1994) And (([H72DEATH_H72DEATH].[DEATH_STATE])=3) And (([H72DEATH_H72DEATH].[DEATH_COUNTY_NAME])="MARICOPA"));


    Hope this helps.

  3. #3
    Join Date
    Dec 2002
    Posts
    2

    Oracle to Access Copy

    Create a Link from your Access Database to your Oracle Database

    Enter something like this to copy data from the Oracle Database to
    an Access Table.

    This is an example from a Death Database I work with.


    SELECT * INTO Access_Table
    FROM H72DEATH_H72DEATH
    WHERE ((([H72DEATH_H72DEATH].[DEATH_BOOK_YEAR])=1994) And (([H72DEATH_H72DEATH].[DEATH_STATE])=3) And (([H72DEATH_H72DEATH].[DEATH_COUNTY_NAME])="MARICOPA"));


    Hope this helps.

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