ACC: Paste Link to Microsoft Excel Displays First Field Name Only (99316)


The information in this article applies to:

  • Microsoft Access 1.0
  • Microsoft Access 1.1
  • Microsoft Access 2.0
  • Microsoft Access for Windows 95 7.0
  • Microsoft Access 97
  • Microsoft Excel for Windows 2.0
  • Microsoft Excel for Windows 2.01
  • Microsoft Excel for Windows 2.1
  • Microsoft Excel for Windows 2.10c
  • Microsoft Excel for Windows 2.10d
  • Microsoft Excel for Windows 3.0
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.

REFERENCES

For more information about copying data, search the Help Index for "copying data," or ask the Microsoft Access 97 Office Assistant.
Modification Type:MajorLast Reviewed:5/9/2003
Keywords:kbinterop kbprb KB99316
©2002 Microsoft Corporation. All rights reserved.