Need to import data from the row 15 in a Excel file to Sql Table using SSIS.

• sandeep1188

  Old Hand

  Points: 389

  More actions

  May 11, 2011 at 5:01 pm

  #237274

  The source Excel file for me has some description in the leading 15 rows, I want to skip it and start the data load from the row 15. Please provide your thoughts on this.

  The column headers are actually row 13. I don't know how to specify that the information starts at row 13 and data from row 15.Please help me out in this.

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  May 12, 2011 at 1:01 pm

  #1323923

  Check this thread out:

  http://social.msdn.microsoft.com/forums/en-us/sqlintegrationservices/thread/947FA27E-E31F-4108-A889-18ACEBCE9217

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP