Convert .xls to Access 97 file

[John Abbott]

I have a bunch of old data stored in Excel spreadsheets
that I am trying to convert to Access 97 database files.
I've been trying to do it with File-->Get External Data,
but Access refuses to recognize .xls files. I have tried
converting the data to comma delimited files but they go
unrecognized as well.

I assume this is because I am missing the necessary
drivers. I have been searching for them in vain, it would
really help if I knew what they were called, and where to
get them.

Can anyone tell me this info? If there is a better way to
solve this problem that would be nice to know as well.

John Abbott
(e-mail address removed)

 

[John Nurick]

Hi John,

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 C:\Windows\System32 or
C:\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

 

[Derek Best]

Hi John

If the xls files are not too large you can just "select all" and ctrl-c
(copy to clipboard) then paste (ctrl-v) into an access datasheet. The
columns in the datasheet wikll have to match the spreadsheet.

Derek