Page 1 of 1

Oracle Export to MDB

Posted: Tue 30 Jan 2007 20:21
by chavetaz
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...

Posted: Wed 31 Jan 2007 07:56
by Challenger
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.