Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 292269 - Last Review: June 25, 2004 - Revision: 2.0
ACC2000: Unable to Import Excel Spreadsheets and HTML Files
This article was previously published under Q292269
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 ACC97 version of this article, see
303804Â
(http://kbalertz.com/Feedback.aspx?kbNumber=303804/EN-US/
)
.
For a Microsoft ACC2002 version of this article, see
303805Â
(http://kbalertz.com/Feedback.aspx?kbNumber=303805/EN-US/
)
.
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 "Import Spreadsheet Wizard" or "Import HTML 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 2000, the correct version begins with the number 9. For example, the version might be 9.0.0.2607. 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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=267279/EN-US/
)
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.
- Click Start, point to Search, and then click Files or Folders.
- In the Search for files or folders named box, type Accwiz.dll, and then click Search now.
- In the Search Results pane, right-click the first file listed, and then click Properties on the shortcut menu.
- Click the Version tab, note the file version for that file and the folder in which it was found, and then click Cancel.
- 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.
- 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
APPLIES TO
- Microsoft Access 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please