Export data from oracle to access

Hi,

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

thanks a lot

pst.

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]

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

Thanks a lot. I tried importing using ODBC source and it worked fine.