SQLSearcher
asked on
Excel SSIS import table on a different row
Hello Experts Exchange
I have a Excel spreadsheet that I want to automatically import into SQL Server 2008, but the table in the excel spreadsheet is on row 31, how can I configure SSIS to ignore the first 30 row and start on row 31?
Regards
SQLSearcher
I have a Excel spreadsheet that I want to automatically import into SQL Server 2008, but the table in the excel spreadsheet is on row 31, how can I configure SSIS to ignore the first 30 row and start on row 31?
Regards
SQLSearcher
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the grade. Good luck with your project. -Jim