XL thru ADO

Results 1 to 2 of 2

Thread: XL thru ADO

  1. #1
    Join Date
    Dec 1969

    Default XL thru ADO

    &#060;%<BR>set con=Server.CreateObject("ADODB.Connection")<BR>set rs=Server.CreateObject("ADODB.Recordset")<BR>con.o pen "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=EMPLOYEE.xls;Extended Properties=Excel 8.0;HDR=YES"<BR>rs.Open "sheet1",con,3,1<BR>Response.Write rs.Fields(1)<BR>%&#062;<BR><BR>I got could find installable ISAM. I&#039;ve checked both the registry and MSEXL40.dll, they are in place.<BR><BR>Any workarounds?<BR><BR>RAJ.

  2. #2
    Join Date
    Dec 1969

    Default RE: XL thru ADO

    this usually means there&#039;s an unrecognised parameter in the conn string. where&#039;d you find this sample code?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts