How to open Excel spreadsheet in ASP

[donishere]

What's the ASP/VBA command to open an Excel spreadsheet?

 

[tlhawkins]

This will open an excel spreadsheet:

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=c:\somepath\mySpreadsheet.xls;" & _
           "Extended Properties=""Excel 8.0;HDR=Yes;"";"

Where "HDR=Yes" means that there is a header row in the cell range
(or named range), so the provider will not include the first row of the
selection into the recordset. If "HDR=No", then the provider will include
the first row of the cell range (or named ranged) into the recordset.

There are several different methods for actually using the spreadsheet here is a link with a lot more info:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q278973

Hope it helps.
Have fun.