DoCmd.TransferSpreadsheet

[aziz rasul]

When I use DoCmd.TransferSpreadsheet acExport based on a table, why do the captions not appear on the first row but the field names themselves?

 

[G37Sam]

http://msdn.microsoft.com/en-us/library/office/aa193071(v=office.10).aspx

Read about the HasFieldName property

 

[aziz rasul]

So your saying it can't be done according to the link you've posted, in which I can just use a select query with aliases to generate the field names I want.