importing data from excel to sql server thru DTS

• keywestfl9

  SSCertifiable

  Points: 5215

  More actions

  February 4, 2009 at 9:42 pm

  #206280

  i have lot of records in excel with 20columns approximately

  in the table there is an identity column and 20 columns as it is in excel

  i try to do import/export wizard to import the data to sql server. it works by enabling idenity insert

  i insert in the sorted order for the a field (Child name) but when i do a group by

  like

  select childname from table group by child name ...the data is retrieved in different order and not the way it was inserted.

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  February 4, 2009 at 10:39 pm

  #938602

  You have made a statement, not asked a question. What do you want?

  Also, you speak of DTS, yet you are posting in the SSIS forum. They are not the same thing.

  The default ordering of data in a SQL Server table is close to meaningless. Use SELECT ... ORDER BY to force the ordering to be as you would like.

  Phil

  ---