import data from excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

excel file import missing - 06 Aug 2004 15:45 GMT

We have several computers, networked, pointing to the same database. In one
computer when I go to file/getexternal data/import , the dialogoue box does
not show excel files (drop down arrow). The rest of the computers are OK. Im
have reinstalled win98, access 97, but still the computer refuses to show
.xls files. What am I missing?

Reply to this Message

BerHav - 06 Aug 2004 16:27 GMT

Hi,

try re-registering :

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.

HTH,
Bernd

> We have several computers, networked, pointing to the same database. In one
> computer when I go to file/getexternal data/import , the dialogoue box does
> not show excel files (drop down arrow). The rest of the computers are OK. Im
> have reinstalled win98, access 97, but still the computer refuses to show
> .xls files. What am I missing?

Reply to this Message