Importing "Files of Type" only lists two file types! WTF?

[Guest]

Hi All,

Got a strange problem here... I have the same version of MS Access (that
came as part of Office 2000 Pro) locally on my workstation and also on
another machine. Problem is, both are the same version, both a full installs,
running on very simular systems and one can only import "Microsoft Access"
and "ODBC" where as the other has those choices and ton more, namely Excel,
Text, Htm, and a bunch of others.

I cannot figure out why one of the machines lists only the two options of
Access and ODBC, while the other has about a dozen file types that it can
import... The user on the other machine needs to import Excel stuff and
cannot and it is frustrating...

Just to explain closer what I am trying to do, create a new blank DB. Open
it. Go to FILE, GET EXTERNAL DATA, IMPORT and look at the list of file types
under "FILES OF TYPE". One machine lists the above mentioned 2, the rest list
a host of others.

HELP!

 

[Arvin Meyer]

The only time I've ever seen anything like that was when the install failed
to copy all the data filters. The best remedy for that was to uninstall,
reboot, and reinstall everything, making sure that everything went correctly
by being attentive to the machine.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Douglas J Steele]

This sounds like the problem discussed in
http://support.microsoft.com/?id=209805



Look for the following files (they should be in your System folder), and use
regsvr32.exe to reregister them:
Msexcl40.dll (Microsoft Excel)
Msexch40.dll (Microsoft Exchange)
Msltus40.dll (Lotus 1-2-3)
Mspbde40.dll (Imprise Paradox)
Mstext40.dll (Text)
Msxbde40.dll (Dbase)