Import Access file

  • Thread starter Thread starter Tamara
  • Start date Start date
T

Tamara

I have always been able to import data from an excel or
word file by using 'Get external data' and then Import.

However, I tried today, the option to import is not
working - when I click onto import it flashes quickly
once and then nothing happens

I've tried removing and reinstalling Office
2000, I have installed access by itself all to no avail
and the problem persists.

Any suggestions please ?

Tamara
 
Are you using Windows 2000? If so, what is your service
pack? I too cannot import, I found that SP4 seems to have
changed something in the odbc driver.
 
Hi Tamara,

This is usually a registry problem.

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


I have always been able to import data from an excel or
word file by using 'Get external data' and then Import.

However, I tried today, the option to import is not
working - when I click onto import it flashes quickly
once and then nothing happens

I've tried removing and reinstalling Office
2000, I have installed access by itself all to no avail
and the problem persists.

Any suggestions please ?

Tamara

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top