I recently wrote an app that takes a tab delimted file in notepad, split the delimeter, and import it into a column in sql. Just one column.

Now I have to do the same thing, only Its a excel sheet (csv) and it has about 17 column headers. I want to do the same thing, but I'm having trouble figuring out how to tell it which column in excel belongs to which column in sql. I've created a sql table with the exact column headers as the excel sheet, and want it to insert accordingly.

I can post the code I used to get the single column data in from my last project. Any help would be great!

Thank you and I hope this isnt' too confusing.