>Thanks, we are going to give that a try. I did find a way to do it dirrect, via odbc using UBT60.EXE, but the samples given were pretty bad and I could not make it work. It kept giving error messages, most often 'unable to determine nimber of rows'. Your approach may take a little bit of work, but it HAS to be faster than 60 hours of looping through a fox table to INSERT into the remote Oracle view
Yes this will directly connect to Oracle and start inserting records. I also suggest you drop all indexes [except PKs]. This will give you a big performance boost. After all the records are inserted, re-run your scripts to create the indexes.
Mark McCasland
Midlothian, TX USA