To script out a table, I recommend Enterprise Manager (it's "free"). There
are many other programs that will script out the metadata for the db. One
that does both the db and the table data is SQL ScriptWriter:

http://ourworld.compuserve.com/homepages/neil_butterworth/ssw2frame.htm.

Also lets you write your insert script query, plus product .csv data.

Additionally, check out these 3 products.

http://www.lockwoodtech.com/auto_inserts.htm - Auto Inserts

http://www.bmc.com/products/distdata/specifications.html (SQL Programmer,
formerly from Sylvain-Faust)

Michael Hotek has some great product reviews at:
http://www.mssqlserver.com/products/

I'm sure Embarcadero and CAST offer programs that do this also.

HTH,

Bruce Clark