Microsoft KB Archive/303805

= You are unable to import Excel spreadsheets and HTML files in Access 2002 =

Article ID: 303805

Article Last Modified on 8/12/2004

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q303805



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 97 version of this article, see 303804.

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



SYMPTOMS
You are unable to import Microsoft Excel Spreadsheets and HTML files. When you use the Import Wizard to import a Microsoft Excel spreadsheet or a Hypertext Markup Language (HTML) file, you see a message in the status bar that says &quot;Import Spreadsheet Wizard&quot; or &quot;Import HTML Wizard,&quot; 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 2002, the correct version begins with the number 10. For example, the version might be 10.0.2627.1. 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 \Accwiz.dll in the Open box, where 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

Additional query words: prb

Keywords: kbprb KB303805

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.