Retrieving Excel data with ASP

[stlWebWiz]

Hello,

I'm wanting to display information from an excel spreadsheet on an ASP webpage. I know its not usually a good idea to use excel as a datasource but I'm only using it to display. I know ASP is capable of retrieving info from an Excel spreadsheet, but I have know idea what the code would look like.

Any help/code snippet would be greatly appreciated

STLWW

 

[Sheco]

Do you want Excel to open in the browser like what happens if you drag the icon for an excel file and drop it into the browser window?

Or do you want to read data from the file and then format it as an HTML page?

 

[steven290]

here you go

Set conn = CreateObject("ADODB.Connection")
conn.ConnectionString =  "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq="& server.mappath("MyExcel.xls") & ";"
conn.Open()


sql="SELECT * FROM [sheet1$]"
conn.execute(sql)