How get col headings when export to Excel ??

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

When I use the 'TransferSpreadsheet' command to export my
query to Excel, how do I get the column headings from my
query in there? I can get them in the first spreadsheet
row, but that is not what I want, I want them as column
headings in Excel?
I've tried the 'Has Field Names' parameter as Yes and No
but it does not do what I want.
I'm using Access 2000. HELP my manager needs this
yesterday!
 
Back
Top