Import Error

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

I have a user who is receiving this error.
"The wizard is unable to access information in the file
C:\Documents and Settings\Jalpern\My Documents\ etc...
Please check that the file exists and is in the correct
format."
The user has been running this procedure over a year now
with no other issues. No changes have been made to the
computer as well. Have tried running office 2000 repair
but to no avail. Any help would be appreciated.

Thanks,
Brad
 
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
 
Back
Top