Getting ride of headings

[Burt Rosner]

Dear Sir/Madam.

I'm trying to transfer data from a table to an xls file.
Everytime I do, the headings from the table show up on the
first line in the xls file. How can I eliminate the
heading showing up in the xls file?

Thanks, in advance, for your answer.

Burt

 

[Cheryl Fischer]

Burt,

I would use the TransferSpreadsheet method to export my data. If you check
this out in VBA Help, you'll notice that the method has an argument
"HasFieldNames". It can be set to True to transfer the field names or
simply left out of your code to use its default setting of False.

hth,

 

[Burt Rosner]

-----Original Message-----
Burt,

I would use the TransferSpreadsheet method to export my data. If you check
this out in VBA Help, you'll notice that the method has an argument
"HasFieldNames". It can be set to True to transfer the field names or
simply left out of your code to use its default setting of False.

hth,

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX





.
Thanks Cheryl. That is a big help

Burt