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.
.
|