I have a series of excel file with several worksheets in each file. The
data that I need to import starts on row 8. Is there a way to get the
DTS to ignore the first 7 rows of data as they are just header data.
Also how can I pull the info from each workbook?

So on the last page of the data pump there are two properties

First Row
Last Row

You can set the value you need here

Last Row must be > First Row

Allan

"aswatson76 (AT) gmail (DOT) com" <aswatson76 (AT) gmail (DOT) com> wrote