Import Wizards Disabled

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have installed the latest Windows security updates (XP-Pro) and SP8 for the
jetdatabase engine, plus set the macro security level to low, but I can still
not import Excell data sheets.

What do I do next?????
 
What happens when you try? Do you get an error? If so, what is it?

If the import wizards don't work at all, reregister ACCWIZ.DLL using
regsvr32.exe

If it's a case that you don't get an option for Excel, look for the file
msexcl40.dll (msexcl35.dll if you're using Access 97) in your system folder,
and use regsvr32.exe to reregister it.
 
Thanks, Doug, but it didn't work. I copied the file into the System32 folder
and ran regsvr32 accwiz.dll to no avail. Windows reported a successful
registration but still none of the wizards work. The file import widow opens
but when a file is clicked it does not fill in the file name field and if the
name is typed in, nothing happens after the import button is clicked.

I'm running Win-XP-Pro and Office Pro 2003. This was not a problem until
recent automatic installs of Windows security updates.
 
Have you got the Office 2003 SP? Seems to me there were problems with the
Excel wizard that were fixed in the SP.
 
I will check the updates for Office tonight.

Although I can see the ACCWIZ.DLL file, when I run the command line:
regsvr32.exe C:\Program Files\Microsoft Office\OFFICE11\ACCWIZ.DLL
or
regsvr32.exe C:\Program Files\Microsoft Office\OFFICE10\ACCWIZ.DLL
(both exist) all I get is a fail message, that "C:\Program" could not be
found! I've added underscores to replace the spaces and have taken the spaces
out completely and get the same results. If I copy the dll to the System32
folder and run
regsvr32.exe ACCWIZ.DLL
it says its successful but it doesn't fix the problem.

I'll monitor for reply but will post again after doing any SP installs.
 
You need quotes around the path when there are spaces in it ...

regsvr32.exe "C:\Program Files etc."

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
After completing all available Windows, Jet, and Office 2003 service paks and
about to give in and pay Microsoft their rediculous support fee to fix
something "MICROSOFT" tore assunder, I tried one last time and the following
command line worked!

regsvr32.exe accwiz.dll

Eureka! The problem is now fixed. Thanks to you both.
 
Back
Top