Excel Export- Field Names in first row of spreadsheet

[Rich1234]

Hi

I have done a lot of "digging" through posts to try to find the answers I
need.....

I am setting up an export to excel. I have read in the Access help File,
TransferSpreadsheet Action, that it is not possible to export to Excel
without the Field Names appearing in the first row of the spreadsheet. (Is
there any way around this? Or is it possible to have the field names appear
in the "horizontal axis" at the top of the spreadsheet where A, B, C etc
appear as column names by default?)

I have read in posts that a way to put the field names in column headers in
the spreadsheet is to use a "make table query." How do I do this? I would
like to have a button that the user presses on an Access form to save just
one field from one table to an Excel file.
This is new to me... if you could post what is needed step by step
(including code) I'd be very grateful.

TIA
Rich



Having the field names appear in the first row of the spreadsheet is a pain
as it means they will have to be physically deleted by the user first!

TIA
rich

 

[Rich1234]

I meant to post this in Import/Export subject, not macros!
I have just re-posted this question there.. please reply there not here

Thank you
rich