suppress headers in query for export to Excel

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
 
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.
Click to expand...


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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I freeze the swimlane headers? 0
I'm John, My first post. 0
Creating Different Headers in Word 0
Embedded Excel into Word with Tables 0
Append Crosstab Query to Existing Table 0
Loop through pages and insert header image 0
column header needs '#' symbol 0
Table of content - format does not get saved 2

Top