Export Access table to Excel without column headers

[shanef1981]

Hey Folks!

How would I achieve the above?

Everything I have tried so far has yielded no result.

All I want to do is to have access determine a filename to save as (from a form) and export a table to that filename WITHOUT the column headers.

Any help would be great

Thanks

 

[Remou]

Would a CSV file suit, it can be opened by Excel?

 

[shanef1981]

I would prefer not to, as it ends up with a customer and they specified Excel.

I'm trying to remove any manual intervention from the process, to eliminate any chance of human error.

Cheers

 

[Remou]

It seems to me that you will need to use a little automation. You can OutputTo CSV and openn and save as XLS, or you can export xls and use automation to delete the first row. I do not think you can use TransferSpreadsheet without a header row.

 

[MikeC14081972]

Why can't you use

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "query Name", "Filename",[COLOR=red]False[/color]

 

[shanef1981]

it doesn't work, it still places the column header in the file...