How to generate SQL Insert Script From SQL Server

[Jigs]

Hi All,

First of Sorry, becuase I am posting off topic. I have 2 databases. One in Access and another in MS SQL Server 2000.

DTS Import Export wizard transfers the data between Access and SQL Server well. I am able to get the SQL Scripts for "Create Table", but How to get the SQL Script for "Insert Into Table ..." ?

Can any one please help me out to solve this problem?

Thanks a lot in advance,

Regards,

Jignesh

 

[RuralGuy]

Download and use the SQL Server 2000 Books Online (Updated 2004)