cannot import text file

[rodelanandamarga]

When I try to import text file, the file type on Microsoft Access 2000
version does not show all files. It only shows specific format like, excel;
access, dbIV etc.

 

[G. Vaught]

Most likely when the Office suit was installed the typical install was
selected. Install Office again and select the Add/Remove programs and review
all the items under Access.

 

[John Nurick]

The Import and Link dialogs in Access don't have an "all files" file
type option: you have to select the specific type you want to import.

If there's no "Text Files (*.txt, *.csv...)" entry in the dropdown list,
or if any other entries are missing, you need to re-register the
appropriate DLL:
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.


If you are trying to import a text file with a non-standard extension
(e.g. .dat instead of .txt), http://support.microsoft.com/?id=304206 or
this http://support.microsoft.com/?id=306144 .