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

• 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

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

Additional query words: XL97

Keywords : kberrmsg
Version : WINDOWS:
Platform : WINDOWS
Issue type : kbbug