Access 97 won't import text files

[Michael Quinion]

I've just had to reinstall Access 97 (part of Office 97
pro) but find that the text import converter isn't
available when I select "File | Get External Data | Import"
- there's no text option under "files of type". How can I
get this working?

 

[Ken Smith]

Do a re-install of additional components.

 

[John Nurick]

Hi Michael,

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

 

[sakieboy]

I've been doing the same stuff that you are doing. It
turns out that Excel won't import it, unless, the field
columns in the database match the field columns in the
text file. Try a simple first just to make sure it works,
if it does, then you know that there is something wrong
with the fields that you have create in Access.


Hope this helps...