Export data from Oracle to Access
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Export data from Oracle to Access

  1. #1
    Join Date
    Apr 2001
    Posts
    17

    Unhappy

    hi guys,

    How can I use tables from oracle in MS Access vice versa.

    or how I can export data from Oracle to MS Access

    Please help me :.-(

  2. #2
    Join Date
    Jul 2000
    Posts
    243
    Hi

    use odbc.

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    In Oracle there is a utility called Database Migration Assistant from Microsoft Access to Oracle.Run this utility and it will help to migrate ur data from Access to Oracle.
    In case of any help please be free to ask me at rohitsn@altavista.com


    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

  4. #4
    Join Date
    Jul 2000
    Posts
    243
    Hi

    rohitsn is right, but if you need to work on line with, say, data from oracle via an access window, update the data in access window and commit the data to the oracle database, ODBC is the way to do it. you can create the connection from access in some user friendly steps.

  5. #5
    Join Date
    May 2001
    Location
    London
    Posts
    149
    Hi all

    Can anybody tell me the exact process of copying data from
    Oracle db to Access

    Thanks
    Paresh


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