No "text file" option on import or link

J

jmaldrich

I have a user who has Access 2000 and when he tries to open a CSV file
in Access, he gets "unknown database type" or some such error. He only
has two options in his Access for file type when trying to import
external data: 1) MS Access file (MDB) or 2) ODBC driver.

I personally installed Access from the original install media and made
double-sure that EVERYTHING was installed, including all the
filters/convertors. Funny thing is that a couple days prior to
installing Access for him, I installed it on another computer (as an
upgrade for the other user) and the other user has the option to
import. I'm wondering if I shouldn't just uninstall all of Office 2000,
reinstall office 97 and then upgrade him.

Anyone ever see this problem before? HELP!
 
J

John Nurick

Remember that Access can't actually open a textfile, it can only import
or link the data into a table in an already-open Access database.

It sounds as if you need to re-register the following DLLs:

msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))
 
Top