Microsoft KB Archive/92891

From BetaArchive Wiki

ACC1x: "Invalid Range" Error When Importing Spreadsheet Range


The information in this article applies to:

  • Microsoft Access versions 1.0, 1.1
  • Microsoft Excel for Windows, versions 4.0, 4.0a


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.


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.


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).


This behavior is by design.


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

Additional query words: cell

Keywords : kberrmsg kbinterop
Issue type : kbprb
Technology :

Last Reviewed: November 4, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.