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?

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.


On Wed, 7 Sep 2005 21:39:02 -0700, "supemsd"
<(E-Mail Removed)> wrote:

>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 [Microsoft Access MVP]

Please respond in the newgroup and not by email.

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

"John Nurick" wrote:

> 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.
>
>
> On Wed, 7 Sep 2005 21:39:02 -0700, "supemsd"
> <(E-Mail Removed)> wrote:
>
> >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 [Microsoft Access MVP]
>
> Please respond in the newgroup and not by email.
>
>