Getting ride of headings

  • Thread starter Thread starter Burt Rosner
  • Start date Start date
B

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

Burt
 
Back
Top