We have to migrate data from an asortment of Fox databases to Oracle.
At present, as the Fox tables range from 2 DOS - VFP 5, we use ans external view to the fox table (IN 1) and an external view to the oracle table (IN 2). As Fox is fixed width, we are using the following p-code to do it.

Select 1
do while !EOF()
scatter memvar
insert into oratbl(b,c,d,...)
values(RTRIM(b), RTRIM(c)....)
select 1
skip 1 in 1
loop
TABLEUPDATE(oratbl)
The problem is, it takes an average of 2 seconds a record. We just did a SMALL table with 18000 records. I'm sure you can do the math, it ran all weekend.
Can anyone suggest a faster way?