No option to import Excel format

K

Kevin

Office 97 Standard and Access 97(separate package)
Installed both using the Change Option/Select All but
cannot get the other formats to install. I followed the
Valupak instructions using both Office setup and Access
setup with no luck. Anyone have suggestions? Why will
it not install the Excel, comma-separate, and other file
formats?
 
J

John Nurick

Hi Kevin,

This is a common problem. 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
msexcl35.dll (Excel)
msxbse35.dll (dBase)
mspdox35.dll (Paradox)
mstext35.dll (Text, CSV, tab-delimited))
In Access 2000 and later, the filenames contain 40 instead of 35.

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
 
D

DJ

Also, Joe F.'s method... thanks guys!

Start, Run, then enter command line for appropriate dll
regsvr32 msexcl35.dll (for Excel)
regsvr32 msxbse35.dll (for dBase)
regsvr32 mspdox35.dll (for Paradox)
regsvr32 mstext35.dll (for Text, CSV, tab-delimited)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top