L
lallen
Is it possible to suppress the headers in a query? I'm exporting to Excel,
and I don't want the header row.
....Larry
and I don't want the header row.
....Larry
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
lallen
I'm using File - Export.
....Larry
....Larry
bhicks11 via AccessMonster.com said:How are you exporting? If you use VBA Transferspreadsheet method, there is a
option to set HasFieldNames to true or false.
Bonnie
http://www.dataplus-svc.com
K
Ken Snell \(MVP\)
bhicks11 via AccessMonster.com said:How are you exporting? If you use VBA Transferspreadsheet method, there
is a
option to set HasFieldNames to true or false.
This argument is not used by TransferSpreadsheet when exporting to EXCEL; it
always exports the field names regardless of what you put for this argument
in your code or macro. This argument works only for imports.
L
lallen
Does that mean that there is no way to suppress the headers when exporting to
Excel?
....Larry
Excel?
....Larry
K
Ken Snell \(MVP\)
The only way I know is to use Automation and write the data directly into
the EXCEL spreadsheet file from a recordset.
the EXCEL spreadsheet file from a recordset.
L
lallen
Thanks Ken.
....Larry
....Larry
Ken Snell (MVP) said:The only way I know is to use Automation and write the data directly into
the EXCEL spreadsheet file from a recordset.
--
Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/