Import data from excel 2003 to MS SQL Server 2000

• Neeraj Jain-376956

  Newbie

  Points: 9

  More actions

  December 18, 2006 at 10:48 pm

  #69368

  How to import Excel 2003 Data having excel column data more than 255 charcters to MS SQl Server 2000

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 19, 2006 at 1:26 am

  #678864

  When you are configuring dts package ...Are you creating table from source?

  If you are not creating table from source(Excel) you can change the size of column width...

  Or you can create sql table first then map that table with excel..

   

  MohammedU
  Microsoft SQL Server MVP