>Hello,
>
>I would like some ideas how to upload the Foxpro table to Oracle Unix
>table from the connection methodogy to the conversion field by field.
>
>FOXTABLE.DBF (Source table) to ORACLETABLE.ORA (Target table)
>NAME CHAR(20) NAME CHAR(20)
>
>Any source codes samples would be really appreciated !!!
>
>Thanks in advance,
>Paul

Here is some code that updates an Oracle table(cur_sys_inv) from two VFP tables(inventory.dbf and username.dbf)
UPDATE cur_sys_inv;
SET sys_status = ALLTRIM(inventory.status),;
cinv_time_stamp = inventory.timesent,;
current_location = ALLTRIM(inventory.location),;
current_site = username.site_name;
WHERE ALLTRIM(cur_sys_inv.ew_serno) = ALLTRIM(inventory.serialno);
AND ALLTRIM(cur_sys_inv.ew_mds) = ALLTRIM(inventory.mds)
If this is not what you are looking for I may have something else that will help.
Sammie