Excel is grayed out when trying to import to access 97

[Bill Ross]

I had to re install Access 97 the other day. I went into
my database to get external data from an excel file.
Excel is grayed out. Could not retrieve that type of
file. This wasn't a problem before reinstalling. Reason
for reinstalling was because of an error message
concerning memory allocation. Reinstalling took care of
that error but the new problem started. Any help would be
appreciated.

 

[John Nurick]

Hi Bill,

This is usually caused by a problem with dll registration. However if
you've just re-installed Access it's probably first worth installing the
latest service pack for the Jet database engine, which I think is at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;172733

If that doesn't solve the problem, Look for the following files on your
hard drive: msexcl35.dll, msxbse35.dll, mspdox35.dll, mstext35.dll
(they're probably in your System32 folder).

msexcl35.dll is the one for Excel; the others are for dBase, Paradox and
text files.

Assuming you find them, use regsvr32.exe to register them. The simplest
way is just to drag and drop the dll's icon onto the regsvr32.exe icon.

I had to re install Access 97 the other day. I went into
my database to get external data from an excel file.
Excel is grayed out. Could not retrieve that type of
file. This wasn't a problem before reinstalling. Reason
for reinstalling was because of an error message
concerning memory allocation. Reinstalling took care of
that error but the new problem started. Any help would be
appreciated.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

 

[Bill Ross]

John,

Thanks for the help, dragging and dropping did the trick.

Thanks again

Bill

-----Original Message-----
Hi Bill,

This is usually caused by a problem with dll registration. However if
you've just re-installed Access it's probably first worth installing the
latest service pack for the Jet database engine, which I think is at
http://support.microsoft.com/default.aspx?scid=kb;EN- US;172733

If that doesn't solve the problem, Look for the following files on your
hard drive: msexcl35.dll, msxbse35.dll, mspdox35.dll, mstext35.dll
(they're probably in your System32 folder).

msexcl35.dll is the one for Excel; the others are for dBase, Paradox and
text files.

Assuming you find them, use regsvr32.exe to register them. The simplest
way is just to drag and drop the dll's icon onto the regsvr32.exe icon.

I had to re install Access 97 the other day. I went into
my database to get external data from an excel file.
Excel is grayed out. Could not retrieve that type of
file. This wasn't a problem before reinstalling. Reason
for reinstalling was because of an error message
concerning memory allocation. Reinstalling took care of
that error but the new problem started. Any help would be
appreciated.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.