Microsoft KB Archive/99316

= ACC: Paste Link to Microsoft Excel Displays First Field Name Only =

Article ID: 99316

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition
 * Microsoft Excel 2.0 Standard Edition
 * Microsoft Excel 2.01
 * Microsoft Excel 2.1 Standard Edition
 * Microsoft Excel 2.10c
 * Microsoft Excel 2.10d
 * Microsoft Excel 3.0 Standard Edition

-



This article was previously published under Q99316



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
When you paste link a table from Microsoft Access to Microsoft Excel versions 3.0 and earlier, only the first field name of that table appears in the spreadsheet.



CAUSE
Microsoft Excel versions 3.0 and earlier need to know the exact dimensions of the spreadsheet area that you are pasting to before you choose the Paste Link command.



RESOLUTION
To paste link a table to Microsoft Excel versions 3.0 and earlier, first select the entire area on your spreadsheet. Another option is to use the Paste command, rather than the Paste Link command.



MORE INFORMATION
The following steps will result in an unsuccessful paste link in Microsoft Excel versions 3.0 and earlier. These same steps will successfully paste link a table to later versions of Microsoft Excel.

Steps to Reproduce Behavior

 * 1) Start Microsoft Access and open the sample database Northwind.mdb (or NWIND.MDB in versions 1.x and 2.0).
 * 2) In the Database window, select the Customers table.
 * 3) On the Edit menu, click Copy.
 * 4) Start Microsoft Excel and create a new worksheet.
 * 5) On the Microsoft Excel Edit menu, click Paste Link.

