Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #72.7K
I copied book1.xls into IISServer c:/inetpup/wwwroot objConn.Open "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;DBQ=" & Server.mappath("/book1.xls") &";ReadOnly= true ; UID=admin;" Dim strSQL excelfilename = "Book1.xls" strSQL = "select * from " & excelfilename Dim objRS Set objRS = Server.CreateObject ("ADODB.RecordSet") objRS.Open strSQL, objConn,3,3 When I execute the page Error Type: Microsoft OLE DB … |