ACC97: Unable to Import Excel Spreadsheets, HTML Files, or Text Files (303804)


The information in this article applies to:

  • Microsoft Access 97
This article was previously published under Q303804
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

For a Microsoft Access 2000 version of this article, see 292269.

SYMPTOMS

You are unable to import Microsoft Excel Spreadsheets, Hypertext Markup Language (HTML) files, or text files. When you use the Import Wizard to import a Microsoft Excel spreadsheet, an HTML file, or a text file, you see a message in the status bar that says "Import Spreadsheet Wizard" or "Import HTML Wizard," or "Import Text Wizard," but the wizard is not visible. If you quit Microsoft Access and open the Task Manager, the Task Manager shows Access as still running.

CAUSE

This behavior can occur because you do not have the correct version of Accwiz.dll registered on your computer.

RESOLUTION

To resolve this behavior, register the correct version of Accwiz.dll. For Access 97, the correct version begins with the number 8. For example, the version might be 8.0.0.4323. To register the Accwiz.dll file, follow these steps.

NOTE: The following steps require that you have Regsvr32.exe installed on your computer. For additional information about how to obtain Regsvr32.exe, click the article number below to view the article in the Microsoft Knowledge Base:

267279 ACC2000: Regsvr32.exe Available in Download Center

NOTE: Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
  1. Click Start, point to Search, and then click Files or Folders.
  2. In the Search for files or folders named box, type Accwiz.dll, and then click Search now.
  3. In the Search Results pane, right-click the first file listed, and then click Properties on the shortcut menu.
  4. Click the Version tab, note the file version for that file and the folder in which it was found, and then click Cancel.
  5. Repeat steps 3 and 4 for all files listed in the Search Results pane so that you can identify the folder containing the version of Accwiz.dll that you need to register, and then close the Search Results dialog box.
  6. Click Start, click Run, and then type regsvr32 <path>\Accwiz.dll in the Open box, where <path> is the path of the folder containing the correct Accwiz.dll version. Press ENTER.
This process registers the correct version of Accwiz.dll and allows the import process to proceed as it should.

MORE INFORMATION

The table below shows what the version of Accwiz.dll should start with for various versions of Access and an example of the complete version number. 
    Access version     Accwiz.dll begins with     Example of version number
    --------------     ----------------------     -------------------------
    Access 2002        10                         10.0.2627.1
    Access 2000        9                          9.0.0.2607
    Access 97          8                          8.0.0.4323
Modification Type:MajorLast Reviewed:9/26/2003
Keywords:kbprb KB303804
©2003 Microsoft Corporation. All rights reserved.