Could not find dll

[agibsonsw]

Hello. Access 2007.

When attempting to use the Import Spreadsheet wizard when I get past the first dialog it says 'Could not locate dll'. It also happened with the lookup wizard but I was able to click past it.

I have both Access 2007 and 2010 but they are supposed to be able to live together and I've not come across this issue before.

I believe it's a question of re-registering dll's but I'm not sure which one(s)? Any ideas pl? Andy.

[agibsonsw]

Actually, it's "error in loading dll".

[HansV]

Try reregistering msexcl40.dll. This is the Excel Jet ISAM file. It can be found in C:\Windows\System32 if you have 32-bits Windows or in C:\Windows\SysWOW64 if you have 64-bits Windows.

[agibsonsw]

Try reregistering msexcl40.dll. This is the Excel Jet ISAM file. It can be found in C:\Windows\System32 if you have 32-bits Windows or in C:\Windows\SysWOW64 if you have 64-bits Windows.

Hi.

I "Ran" regsvr32.exe "C:\Windows\SysWOW64\msexcl40.dll" but still no joy

I re-registered dao360.dll and msado15.dll as well prior to the above as well. Andy. Mmm.. is it then called regsvr64.exe I wonder?

[HansV]

You don't have to use regsvr64 as far as I know.
You might also try AccWiz.dll (in C:\Program Files (x86)\Microsoft Office\Office12 for Access 2007, in C:\Program Files (x86)\Microsoft Office\Office14 for Access 2010).

[agibsonsw]

You don't have to use regsvr64 as far as I know.
You might also try AccWiz.dll (in C:\Program Files (x86)\Microsoft Office\Office12 for Access 2007, in C:\Program Files (x86)\Microsoft Office\Office14 for Access 2010).

Should have mentioned that one as well. I even tried

c:\windows\syswow64\regsvr32.exe "C:\Windows\SysWOW64\msexcl40.dll"

which is, strangely, the 64-bit version. Must be some combination of these I suppose.. Andy.

[HansV]

In the end, you may have to uninstall both versions of Office and install only one...

[agibsonsw]

In the end, you may have to uninstall both versions of Office and install only one...

he, he.. I was just thinking, "I don't want to do that!".

Just trying an Office 2007 repair. I might even bite the bullet and install 2010 SP1 (which I've delayed as long as poss.).

Andy.

[agibsonsw]

Hi. Nope, repair didnt' work.. Have to think about this one..

[agibsonsw]

Hey, fixed (it seems, so far..) Saving the following as a file called 'win32key.reg' and double-clicking it:

Code: Select all

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\TypeLib\{00025E01-0000-0000-C000-000000000046}\5.0\0\win32]

@=hex(2):25,00,43,00,6f,00,6d,00,6d,00,6f,00,6e,00,50,00,72,00,6f,00,67,00,72, 00,61,00,6d,00,46,00,69,00,6c,00,65,00,73,00,25,00,5c,00,4d,00,69,00,63,00, 72,00,6f,00,73,00,6f,00,66,00,74,00,20,00,53,00,68,00,61,00,72,00,65,00,64, 00,5c,00,44,00,41,00,4f,00,5c,00,64,00,61,00,6f,00,33,00,36,00,30,00,2e,00, 64,00,6c,00,6c,00,00,00

So simple when you know how! Andy.

[HansV]

Thanks - but how did you find that?

[agibsonsw]

Thanks - but how did you find that?

What do you mean.. I worked it out myself

Nah, via microsoft, Knowledge Base, then a link to Microsoft Answers:

http://answers.microsoft.com/en-us/offi ... 1db61a9d2a

[HansV]

Thanks again!