I have experienced the very same error. It took me a
long time to get the answers.
My guess is that it is not a DLL regristration issue, if
so read below.
That said, your challenge is most like likely due to the
Access Wizard's attempt to judge how to format data being
imported.
I.e., I had data in a single Excel export column:
123456789 4/12/2003 1157KWH.
My point, Access did not know whether the field s/b a
Date or a number or text.
I my case, the values represented an invoice number; a
date and electrity usage.
The column is a "remark" fiemd in accounting s/w. The
data was imported into Excel and worked fine as text.
Access does not care nor evaluate how Excel's fields are
formatted, it tries to make it's own judgment.
My suggestion is to parse out the data into Excel columns
prior to Excel inport to Access.
Using my example, I had one column each as 1)
text: "123456789" 2) as Date 4/12/2003 3) as Text 1157KWH
I have attached an aggregation of other's thoughts who's
experience and knowledgebase id far greater than mine.
Merry Christmas
********************************************
Re: Importing text file to Access 2000
From: "John Nurick" <
[email protected]>
Sent: 12/22/2003 10:20:21 PM
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