Oracle Export to MDB

chavetaz · Post by **chavetaz** » Tue 30 Jan 2007 20:21

I want to export a table from oracle to mdb, can anybody help me with ideas?
my suggestion:
- run a "desc table_name" and create the MDB
- Copy row by row

(Which component I have to use to exec "desc")

sorry my english
thanks...

Challenger · Post by **Challenger** » Wed 31 Jan 2007 07:56

ODAC 6.00 Beta has the TCRBatchMove component that can transfer data between datasets. But it doesn't create destination table. You can try to use BDE and standard TBatchMove component.