Click here to Skip to main content
15,945,119 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I'm starting with a file that:

0) Contains one or more sheets

1) The names of the sheets are not guaranteed to be the same, but the columns in them are always the same

2) The header row is row #5 (and there is data above this row that I don't want to import).

Essentially, I need to import all of the sheets, starting the import at row 5.

Has anyone got any tips?

What I have tried:

I've made a couple of runs at this with googled info, but the process always falls down because they make assumptions that don't apply to my situation.
Posted
Comments
CHill60 22-Mar-17 13:03pm    
Does it have to be via SSIS or could you write a .NET program to do it?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900