Not allow to import .txt file into Access 2003?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi, I am tryinig to import .txt file into Access database. But in the import
data type, there has been no .txt to choose. What has been changed to Access
2003 in importing?
 
Hi,

I guess you are trying to File -> Get external Data -> Import and then try
to select for 'Files of Type' : Text Files and this is not available.

From info previously posted by John Nurick, Microsoft ACCESS MVP:

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


Cheers,
Bernd
 
In addition to BerHav solution, it may be necessary to re-install Office to
get the text converter. If you did not install Office yourself, most likely
only the typical install was performed. You must use the Full/customize
install to get other converters and wizards. When install Office, always use
the Customize so you can pick and chose what you want, not just what
Microsoft thinks you need.
 
Back
Top