Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_web_howto thread: Reading an Excel file


Message #1 by Nancy Flores <ndtiuflores@y...> on Thu, 27 Jun 2002 02:36:14 -0700 (PDT)
I am trying to display the contents of an excel file
in ASP. Here is my code: 

set oConn= Server.CreateObject("adodb.connection")
        oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;"
& _
           "Data Source=" & newFilepath & ";" & _
           "Extended Properties=""Excel
8.0;HDR=Yes;"";" 

Set RS = oConn.Execute("Select * From name") 

This is the error I got:
The Microsoft Jet database engine could not find the
object 'name'. 


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

  Return to Index