Question

asp如何打开excel表

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Excel Driver (*.xls)};ReadOnly=0;DBQ=" & Server.MapPath("txl.xls")
SQL1="select * from tx"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open SQL1,conn,3,3
以上方法好像不行，错在哪里？

Answer 1

set conn2=CreateObject("ADODB.Connection") '使用oledb方式和Excel的连接
conn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=;Extended properties=Excel 5.0;Data Source="&FilePath

sql = "SELECT * FROM [excels$]"
set rs = conn2.execute(sql)
_________________________________
Extended properties=Excel 5.0这里应该可以设置为更高,7.0以上吧,但是5.0应该可以达到目的了