Extracting Data from SQL Server into a Spreadsheet

[blakemckenna]

I am trying to extract about 5 records from a SQL Server table into a spreadsheet. Basically, I want a snapshot of a table showing it's field names and it's associated field values. I wish to be able to print out this data. What is the best way to do this?

Thanks,

Blake

[Ecniv]

open excel (blank sheet)
open a recordset of the data you want
loop through the field names and output to row 1, columns whichever
loop through records and put into cells under the columns
close recordset

Something like that.
Excel will allow you to record macros to look at. You can either use a reference or just create an object for the excel object.