How do I generate "INSERT into TableA Values(1,2,3)" statements ?

[mb224]

How do I generate "INSERT into TableA Values(1,2,3)" statements from a given table.

I need to generate insert statements for all the records in one table .... and go to another server machine and insert them into a similar table using SQL Query Analyzer.

DTS is not handy to connect the 2 servers to exchange data so this will be very convenient for me!

Will Access2000 perhaps be able to do it easier? Any help is good!

 

[JamesLean]

An easier way might be to use a linked server and then insert directly from one to another:

INSERT table
SELECT *
FROM server2.mydb.dbo.table

--James