cannot import text file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rodelanandamarga - 09 Sep 2005 22:51 GMT

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.

Reply to this Message

G. Vaught - 10 Sep 2005 00:54 GMT

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.

> 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.

Reply to this Message

John Nurick - 10 Sep 2005 10:02 GMT

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 .

>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.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message