Microsoft KB Archive/137936

= ACC: Cannot Enter a Non-Named Range in Import Wizard =

Article ID: 137936

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q137936



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
When you use the Import Spreadsheet Wizard, you cannot select or enter a non-named range of cells. As a result, you must import the entire spreadsheet instead of only a selected portion.



RESOLUTION
If you want to import a non-named range of cells, you can use the TransferSpreadsheet action in a macro or procedure. The TransferSpreadsheet action has a Range argument that you can set to a non-named range, such as A3:D16.



STATUS
This behavior is by design.



Steps to Reproduce Behavior

 * 1) Open any database.
 * 2) On the File menu, click Get External Data, and then click Import.
 * 3) In the Import box, select Microsoft Excel (*.xls) in the Look in box, locate an .xls file on your computer, and then click Import.
 * 4) In the Import Spreadsheet Wizard, try to select rows or columns individually. Note that you cannot select a non-named range.
 * 5) Click Finish to import the entire spreadsheet.

