I cannot get import wizard to work to import excel to access tabl

[supemsd]

With my macro security set to low, I cannot get excel data into an access
table using the standard wizards. They simply do not function. I get an
hourglass for about a tenth of a second and then nothing.

I have reloaded the wizards numerous times from the installation disc.
Something is preventing the wizards from functioning. Any ideas?

 

[John Nurick]

This usually fixes it:

If the import/export wizards don't work at all, or if you get "No object
in this control" re-register ACCWIZ.DLL.

If it's one or more file formats that aren't listed, re-register the
following files
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))
In Access 97, the filenames contain 35 instead of 40.

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.

 

[ThenWhen]

I'm having the exact same problem - and I tried reregistering both dlls
(accwiz.dll - which was located in my program files, and msexcl40 - which was
in system32) no effect. Frustratingly - everything was working last week.

Any additional help would be truly appreciated.

Thanks
Diane Meriwether
thenwhen.com