XL97: Copy and Paste from Access to Excel May Generate Errors

ID: Q192405

The information in this article applies to:

Microsoft Excel 97 for Windows

SYMPTOMS

If you copy records from Microsoft Access and paste them into Microsoft Excel 97, you may receive the following error messages:

   In the Excel Visual Basic for Application Editor, the following error
   may appear:

      File not found

   When you click OK, the following error appears:

      Microsoft Excel cannot paste the data

NOTE: The data is correctly pasted as expected.

CAUSE

This may occur if the following conditions are true:

You copy records in Microsoft Access.
```
    -or-
```
You copy records in a workbook from a second running instance of Excel.
```
    -and-
```
The Excel file in which the data is pasted includes a Visual Basic for Applications module and the file has been saved prior to the paste.

WORKAROUND

To work around this problem, do one of the following:

Do not include any Visual Basic for Applications modules in the workbook into which you want to paste records.
```
    -or-
```
Use Microsoft Query to query the database and return the data directly to Excel. To start a new query, click Get External Data on the Data menu and click Create New Query.
```
    -or-
```
Use a Visual Basic for Applications macro code to query the data and bring it directly into Excel.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows.

MORE INFORMATION

The same errors occur whether you execute this process manually or with Visual Basic for Applications macro code.

REFERENCES

For more information about using Microsoft Query to get external data, click Contents And Index on the Help menu, click the Index tab in Excel Help, type the following text

   Query Wizard, running

and then double-click the selected text to go to the "Get external data by using the Query Wizard" topic. If you are unable to find the information you need, ask the Office Assistant.

Additional query words: XL97

Keywords          : kberrmsg
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: November 4, 1998