Microsoft KB Archive/92891
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:
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
Last Reviewed: November 4, 2000