how to export old table values into new table

• bill-341486

  Grasshopper

  Points: 20

  More actions

  August 17, 2006 at 7:23 am

  #61711

  hi all,i need to export the old table values in to new table currently i am using sql server 2000... is it possible to do this....? 

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  August 17, 2006 at 12:48 pm

  #655520

  There are lots of ways to do it e.g. T-SQL, DTS.  Are the old and new tables in the same database?  Same server? 

  Greg

   

  Greg