importing in acces

[Ashok]

Hi all,
I'm trying to import excel and dbase files in access 2000.
However I don't get that option to select. I've already
reinstalled MSOffice 2000 Professional, but with no luck.
Can anyone help me out ?

Ashok

 

[GVaught]

did you install with the custom option or the typical. The typical does not
install all the appropriate files needed to import or export certain files.
Make sure you have installed, at minimum, Access as a full install with
everything. Custom will allow you to chose those items that are not needed.

 

[John Nurick]

Hi Ashok,

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