Export to Excel without colum headings

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am exporting a table to excel, but when I do the first row in Excel is the
colum headings from the table. I just want the data not the colum headings.
Is there a way to do this?
 
Not by using File | Export or by using TransferSpreadsheet.

You'd need to use VBA code to open the spreadsheet file, and to open a
recordset based on your table, and write just the data to the spreadsheet.

Or use TransferSpreadsheet to export the data, and then use VBA code to open
the spreadsheet file and delete that first row.

Or use TransferText to export the data to a text file (.csv --
comma-delimited file) and use the setting for No Header value in the Headers
argument, and then open the file in EXCEL.
 
Back
Top