ACC1x: "Invalid Range" Error When Importing Spreadsheet Range

 Last reviewed: June 6, 1997
Article ID: Q92891
The information in this article applies to:
  • Microsoft Access versions 1.0 and 1.1
  • Microsoft Excel for Windows, version 4.x

SYMPTOMS

When you try to import a range of cells from a Microsoft Excel version 4.0 spreadsheet into Microsoft Access version 1.x, you receive the following error message: 

   Invalid Range
The Select File dialog box appears after the error message.

CAUSE

You specified an invalid range of cells to import, either by improperly referencing them (for example, R0C0:R5C3), or by providing a nonexistent range name.

RESOLUTION

Reselect the file that you want to import, and then choose Import from the File menu. When the Import Spreadsheet Options dialog box is displayed, make sure you type a valid range reference in the Spreadsheet Range box. This range can be a specific range of cells (for example, A5:B12), or a defined name that refers to a range of cells on the spreadsheet (for example, MYRANGE).

STATUS

This behavior is by design.

REFERENCES

Microsoft Access "User's Guide," version 1.0, Chapter 4, pages 72-75

Additional query words: cell
Keywords : IntpOff IsmExl4 kberrmsg kbinterop
Version : 1.0 1.1
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided

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: June 6, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.