5万元买什么车好:如何实现用ASP读取ECXEL数据

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/01 09:43:46

You can open an Excel Spreadsheet using the \"OLE DB Provider for Microsoft Jet\"

oConn.Open \"Provider=Microsoft.Jet.OLEDB.4.0;\" & _
\"Data Source=c:\\somepath\\myExcelSpreadsheet.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.