ExcelBanter - Connectiong to an Excel Workbook with MSDASQL provider

just check that the correct driver is available on the
host machines.

-----Original Message-----
Hi All,

I have a big problem right now. I have developed an
apllication in Excel VBA. I have the following codes for
connecting to another Excel Sheet

Set cnConn = New Connection
With cnConn
.Provider = "MSDASQL"
.ConnectionString = "Driver={Microsoft
Excel
Driver (*.xls)};" & _
"DBQ=" & sEmpFilePath & ";"
.CursorLocation = adUseClient
.Open
End With

This works find on my development machine which is under
win 2000. When I deploy the application under win 2000
it
still works fine but under win 98 I get the following
error:
Error Number: 3706
Description: Provider Cannot be found. It may not be
properly installed.

Any hint how to get this resolved?

thanks you all.
.