Text File Import

  • Thread starter Thread starter NewUser
  • Start date Start date
N

NewUser

When trying to import delimited text files I do not have
many of the various file types listed in the import
window. For example using Access97 - File - Get External
Data - Import - In the Files of Type drop down box I do
not have text file or Excel options. I've tried rerunning
the setup program and selecting all the data options under
the Data Access configuration. This did not correct my
issue. Thanks.
 
This is a common bug. 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
 
Back
Top