Hi all,

I want to dump some data in XLS without the table header information.

Information on the docmd.TransferSpreadsheet Action is telling me that
the header columns are transferred each timehttp://msdn.microsoft.com/en-us/library/aa164087(office.10).aspx
"When you export a Microsoft Access table or select query to a
spreadsheet, the field names are inserted into the first row of the
spreadsheet no matter what you select in this argument."

As I really do not want the header columns what other options are
available? Is my worst case scenario looping through the table and
copying the information myself just to avoid the header information?

or use the transfer() function to create the worksheet
then open the worksheet (with VBA) and delete the heading row