Problems Exporting MS Excel Files from MS Access 2.0

ID: Q147318

The information in this article applies to:

Microsoft Excel for Windows, version 5.0
Microsoft Excel for Windows 95, version 7.0
Microsoft Access 2.0

SYMPTOMS

Problem 1

After you export data from Microsoft Access version 2.0 to a Microsoft Excel version 5.0 workbook by using the TransferSpreadsheet macro command or the Export command on the File menu, you may receive the following error message

Cannot do that command on nonadjacent cells

while working in Microsoft Excel 5.0 or 7.0. This will only happen if you have exported data from Microsoft Access 2.0 to the same Microsoft Excel 5.0 workbook more than once. You will receive the error message if you try to manipulate the workbook in the following ways:

Insert sheets

Copy and paste between workbooks

Print preview (Microsoft Excel 7.0 only)

Problem 2

In Microsoft Excel 5.0, you may also receive the following error message

not enough memory

if you attempt to delete extra sheets in the workbook one at a time. This will only happen if you exported the data from Microsoft Access 2.0 to an existing Microsoft Excel 5.0 workbook that contained worksheets not exported from Microsoft Access. However, if you group the extra sheets together, you will then be able to delete them.

WORKAROUND

To work around this problem, follow these steps:

Export the data to a Microsoft Excel version 4.0 worksheet, and then transfer the individual worksheets to a Microsoft Excel workbook.

Use the Move Or Copy Sheet command on the Edit menu to move the sheets, one at a time, to a new workbook.

Group the sheets together (hold down the SHIFT key and select the sheets by clicking the Sheet tab). You will then be able to insert, copy, paste, and print preview the sheets.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. This problem no longer occurs in Microsoft Access for Windows 95 version 7.0.

REFERENCES

For more information about the TransferSpreadsheet macro action, search for "Transfer Spreadsheet," and then "TransferSpreadsheet Action" using the Microsoft Access 2.0 Help menu.

Microsoft Access "User's Guide," version 2.0, Chapter 26, "Using Macros to Print Reports or Transfer Data," page 700

For additional information, please see the following article in the Microsoft Knowledge Base:

Q119806 PRA: Exporting Data to MS Excel 5.0 Twice Causes Error

Additional query words: interoperability

Keywords : xlwin
Version : WINDOWS:2.0,5.0,7.0
Platform : WINDOWS
Issue type :