Data Transfer

[jaspjay]

Please help....

How can I transfer table data from a table to another table with additional fields?
The source data is from a ms sql server 7 and the destination is a ms sql server 2000.

[AJ2]

Use DTS Import/Export Wizard with MS OLE DB provider for SQL Server. When comes to the screen "Specify Table Copy or Query", choose "Copy objects and data between SQL Server database"