importing from excel into access

[Guest]

I am using access 97 and excel 97. I am just a learner at this so please bear
with me. I want to import from excel but when i try to select the
spreadsheet i want the drop down box does not show excel files it only shows
different database files. I know i should be able to import this type of
file as i can do it at home on access and excel 2000

 

[John Nurick]

Hi Ann,

If you're used to doing it at home, you know to select "Microsoft
Excel(*.xls)" in the Files of type dropdown on the first Import dialog,
so I'm assuming that Excel doesn't show up there.

The usual reason for this is that some DLL files aren't properly
registered, and the following usually fixes it:

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.