>Bret,
>
>Another option is to use BCP to dump the data out of the server into text files and then APPEND those files into VFP tables. You can do some performance tests but in my experience this is will be quite a bit faster than ODBC but YMMV.

Thanks David, I will ask our Oracle experts about that option.

>
>>My group was given the data as a dump from oracle and we loaded it into our Oracle system. Now I want to know what is the best way to get the data out of Oracle and into our VFP database. The data is huge as one table has 5 million records and the next size is 500,000 records. The data will be given to us twice a week and I am tasked to get the data out of Oracle and into our VFP system. As I have no Oracle experience, I was wondering what would be the best way to do this? Any suggestions would be appreciated, but if you do give one that involves doing something inside of Oracle can you provide a detail explanation. Because as I said I do not know Oracle. What I am hoping for is a fairly automated way of getting this done, so that it can run unattended at night.