can't import/export from/to excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jonathan - 13 Sep 2004 03:38 GMT

The excel date access driver is installed (it is greyed
out and says it is installed in the setup dialogue) but it
is not an option in this machine. I am familiar with using
this and it is on my other machines I've used. This
installation was problematical - I had the "uninstallable
ISAM" and "no licence on this machine" problems too. I can
get around it by exporting to text files but it a real
pain. any ideas?

Reply to this Message

John Nurick - 13 Sep 2004 07:33 GMT

Hi Jonathan,

This sort of problem is usually fixed by re-registering one or more DLL
files.

If the import/export wizards don't work at all, 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.

These problems are discussed in the following MS Knowledgebase articles
among others:
http://support.microsoft.com/?id=292269
http://support.microsoft.com/?id=155666
http://support.microsoft.com/?id=171955
or for Access 2002
http://support.microsoft.com/?Id=283881

>The excel date access driver is installed (it is greyed
>out and says it is installed in the setup dialogue) but it
[quoted text clipped - 4 lines]
>get around it by exporting to text files but it a real
>pain. any ideas?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message