Problems Exporting MS Excel Files from MS Access 2.0

 Last reviewed: March 27, 1997
Article ID: Q147318
5.00 7.00 WINDOWS kbinterop kberrmsg

The information in this article applies to:

  • Microsoft Excel for Windows, version 5.0
  • Microsoft Excel for Windows 95, version 7.0
  • Microsoft Access version 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:

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

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

  3. 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: 

   ARTICLE-ID: Q119806
   TITLE     : PRA: Exporting Data to MS Excel 5.0 Twice Causes Error

KBCategory: kbinterop kberrmsg
KBSubcategory: xlwin

Additional reference words: 2.00 5.00 7.00 interoperability
Keywords : xlwin kberrmsg kbinterop
Version : 5.00 7.00
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 27, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.