Copying Table Data

[Droopy]

I have noticed that when you copy data from an Access table, it also copies the associated column headings.

When you copy a field, control, or action, Microsoft Access includes any associated properties, controls, or action arguments. For example, when you copy a text box control, Microsoft Access copies its label as well.

Is there anyway to avoid this at all? I would like to paste the data into an excel file but do not want the heading row to accompany the data.

Thanks!

 

[Mile-O-Phile]

If you use the TransferSpreadsheet method then you can explicitly state that you don't want to carry the field names over to the Spreadsheet.

 

[bat17]

From A97 Help for TransferSpreadsheet.

When you export Microsoft Access table or select query data to a spreadsheet, the field names are inserted into the first row of the spreadsheet no matter what you enter for this argument.

This may have changed in later versions though

Peter