>I have been franticly searching for a fasyer way to import data from a VFP database into Oracle. Our current method is just to slow, exporting from Fox, so is there a way, via ODBC to import from Fox. So far searching the oracle on-line refenece is not of much help.
We did with ODBC. Here is the step (by memory)
-First our table was VFP so we did Upsizing to Oracle
-Create ODBC via Control Panel
-Create a Remote view in VFP
When you create your view be sure to check the right items in the update criteria.
-You do an append from your table into your view
-And then you use TableUpdate(.T.) / TableRevert()
We did with 300 000 records and it was not slow.
By the way, what's your methode.