How To Delete Top row in Excel Useing DTS Package

• SURESH-995551

  SSC Rookie

  Points: 27

  More actions

  March 29, 2011 at 5:42 am

  #233929

  Hi All,

  I am importing data from Execl i want to delete top row(First row) In my Execl file before importing data into SQL SERVER 2000 useing DTS package and do CSV Formatting Like Replace ',' with ';' and Nothing with 2 spacess.

  Can anyone help me out in this ..

  Thanks

  Suresh

• GSquared

  SSC Guru

  Points: 260824

  More actions

  March 29, 2011 at 6:42 am

  #1304811

  You can skip the top row in the connection manager. Will that accomplish what you need?

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• SURESH-995551

  SSC Rookie

  Points: 27

  More actions

  March 29, 2011 at 7:58 am

  #1304875

  Hi

  Thanks for your reply , But I am new to To This DTS Packages can u help me how to do it in Connection manager

  Thanks

  Suresh