ACC: Paste Link to MS Excel Displays First Field Name Only

• Microsoft Access 1.0, 1.1, 2.0, 7.0, 97
• Microsoft Excel for Windows, versions 2.x, 3.0

SYMPTOMS

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

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 using 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.