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