Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

csv file and insert fields into oracle using coldfusion

Status
Not open for further replies.

Firsttimeprogrammer

Programmer
Feb 10, 2005
8
US
Could any one tell me how to insert records from a csv file into oracle. The problem is there are 12 fields in the csv file but only three fields that are to be inserted.

For example I have col1,col2,col3,col4,col5,col6,col7,col8,col9,col10,col11,col12,. But only need col1, col3 and col4 to be inserted.

The condition for the insert is if column 5 is empty..





 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top