Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

batch /exe file to convert dbf to csv for sqlldr loading..!

685758Oct 18 2010 — edited Oct 18 2010
Hi all,
I am having a tough problem as below.
I need to load a .dbf file into a oracle table by sql loader.
Can to tell me the best way to convert .dbf file to .csv so that I can load it via sql loader.
I need some batch file or exe file code to convert .dbf to .csv file.

i was doing it manually as in below steps.
1- open .dbf file in excel.
2-save it as .csv option.
3-use sql loaderfor converted .dbf file.

I want to save my manual work of excel.Kindly help



kindly light into it...

rgds,
pc
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 15 2010
Added on Oct 18 2010
4 comments
814 views