Sql loader

[howtowork]

Hi,

I am trying to load a csv file however the arrangement of the columns in the file is different than the table I am inserting the data into. Is there a way get the ctl and load the columns in the csv file to match the new table?

csv:
col1, col2, col3

but lets say my table's headings are like:
col3, col1, col2.

Thanks for any help.

 

[Turkbear]

Hi,
Edit the CTL file to list the cols in the order they are in the csv file..The CTL file is what handles the 'mapping' of the incoming data to the correct field in the table.

 

[howtowork]

Thanks, I will give it a try.