Export data from oracle to access
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Export data from oracle to access

  1. #1
    Join Date
    Sep 2000
    Posts
    103
    Hi,

    Can someone tell me how to export data from an oracle (8.1.7) database to an access database?

    thanks a lot

    pst.

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Hi,
    Access can import or link tables from ODBC source, so one way is to create ODBC source for your Oracle DB and then link Oracle tables you need or import data from them.
    Regards,
    Ales


    [Edited by ales on 10-03-2001 at 08:05 AM]

  3. #3
    Join Date
    May 2001
    Location
    Chennai
    Posts
    57
    The best way i would suggest is the use of Oracel COM feature which has been bundled from 8.1.5 onwards...

    COM functions r pretty easy for this kind of functionality....

    Oracle has provided with some demo scripts and examples to support this feature along with the EE installation CD...

    Explore and try this out and let us know about it ...

    Kevin


  4. #4
    Join Date
    Sep 2000
    Posts
    103
    Thanks a lot. I tried importing using ODBC source and it worked fine.

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