-
Expert Member
Foxpro Data Conversion
How to export foxpro data into oracle9i tables?
-
Re: Foxpro Data Conversion
You need to export the data into a .CSV file, from this you can upload to oracle table using sql loader.
-
Expert Member
Re: Foxpro Data Conversion
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 )
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules