This app converts SQL Server .rpt format (outputed by SQL query analyzer) reports to SQL statements in a single SQL script. Unfortunately it doesn't currently work with text columns (varchar,nchar,char,text,blob). All that is required is a "select * from table" in SQL analyzer and change the output to rpt format. Load the rpt into this converter and it should convert it to a sql insert script.

For best results, setup the query so there are no column headers, and the column seperator doesn't appear in any of the data.

This tool is only any use for tables with columns that have simple or small amounts of data, not columns with lots of textual information. A better tool for dumping out tables is SQL Server Dumper which can you be found here.