Article ID: 168219 - View products that this article applies to.
This article was previously published under Q168219
Novice: Requires knowledge of the user interface on single-user computers.
If you select and copy the data in a cell of a table, a query, or a form in Datasheet view, when you paste the data elsewhere, the data includes the name of the column in the datasheet.
You selected the entire cell, not just the data in the cell. When you select and copy an entire cell in Datasheet view, Microsoft Access automatically includes the column name.
Microsoft Access provides two ways to copy and paste data from a cell in Datasheet view. You can select and copy just the data itself, or you can select and copy the entire cell. By default, copying the entire cell includes the column name.
Selecting and Copying Only the Data in a Cell
Selecting and Copying an Entire Cell or Multiple CellsWhenever you select and copy an entire cell or multiple cells in your datasheet, Microsoft Access automatically includes the column name(s) when you paste the data.
For more information about ways to copy or move data in Microsoft Access, search the Help Index for "copying data," or ask the Microsoft Access 97 Office Assistant.
For more information about how to select fields and records in Datasheet view, search the Help Index for "selecting fields and records," or ask the Microsoft Access 97 Office Assistant.
Article ID: 168219 - Last Review: January 19, 2007 - Revision: 2.1
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.