Just nu i M3-nätverket
Jump to content

Excel dokument med ASP


ConnyBrusewitz

Recommended Posts

ConnyBrusewitz

Hej Jag vill öppna en excel dokument med ASP.

 

Vad har jag gjort fel?

<%

set RS1 = Server.CreateObject("ADODB.Recordset")

RS1.ActiveConnection = "driver={Microsoft Excel Driver (*.xls)};dbq=C:\Inetpub\wwwroot\xbvc024_shop\xls\Book1.xls"

RS1.Source = "SELECT Rub1, Rub2 FROM Sheet1"

RS1.Open

Response.Write RS1.Fields("Rub1")

RS1.Close

set RS1 = Nothing

%>

 

Felmeddelandet blir:

 

Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)

[Microsoft][ODBC Excel Driver] The Microsoft Jet database engine could not find the object 'Sheet1'

 

Ändå heter bladet Sheet1?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.



×
×
  • Create New...