create Data Source to Access Microsoft Excel Files

[charon]

Hi
We encounter problem when trying to create Data Source to Access Microsoft Excel Files. The connection string is as below:

objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & XLSFile & ";Extended Properties=Excel 8.0;"

The error message is as below:

Microsoft JET Database Engine error '80004005'

Could not find installable ISAM.
pls advise......

[mehere]

read this link (http://support.microsoft.com/kb/209805) ... about half way down it tells you that you may need to register the Excel ISAM.