How to export foxpro data into oracle9i tables?
Printable View
How to export foxpro data into oracle9i tables?
You need to export the data into a .CSV file, from this you can upload to oracle table using sql loader.
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 <user/password@tnsname> sqlload1.ctl
note :use sqlldr path(ex c:\oracle\bin\sqlldr )