Importing text file to Access 2000

[Kristine]

Hi all,

I'm trying to import a text file (comma delimited) into
Access. Every time I choose File ->External Data ->
Import. I choose the file I want to import and nothing
happens. I do not get the Import Text Wizard to pop up
(though the words 'Import Text Wizard' do appear in the
bottom left hand corner of my screen.

Any ideas why this is happening? How can I get my text
files into Access 2000?

BTW, it does work in Access 97!?!?!

Thanks,
Kristine

 

[John Nurick]

Hi Kristine,

Probably it's the common problem with DLL registration (see below). If
that doesn't fix it, the problem may conceivably be with the text file.
Access 2000 and later are more strict about text file formats than was
Access 97. In particular, line breaks must consist of a Windows-style
CR+LF pair; Mac-style and Unix-style files, with CR only and LF only
respectively, won't work (but there are lots of utilities on the
internet for converting between the three styles.

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