Foxpro Data Conversion

[krishnaindia2007]

How to export foxpro data into oracle9i tables?

[debasisdas]

You need to export the data into a .CSV file, from this you can upload to oracle table using sql loader.

[susarlasireesha]

U open required dbf file in excel and save as .csv ,u convert .csv file to
oracle using sql loader.The following simple example help u

infile 'C:\HR_EMP_LWP_TMP.csv'
REPLACE
into table HR_EMP_LWP_TMP
fields terminated by ','
(emp_NO,yr_mon,lwp) (save this file as sqlload1.ctl)

From command prompt run

c:\oracle\bin\sqlldr sqlload1.ctl

note :use sqlldr path(ex c:\oracle\bin\sqlldr )