如何用ASP读取Excel文件

如何用ASP读取Excel文件

直接读取
注意点:同读取Acc数据一样
dim ExTName
ExTName = "表名"
Set conn =Server.CreateObject("ADODB.Connection")
StrConn="Driver={Microsoft Excel Driver (*.xls)};DBQ="& Server.MapPath(文件路径和文件名)
conn.Open StrConn
Set rs = Server.CreateObject("ADODB.Recordset")
Sql="select * from ["&ExTName&"$] "
rs.Open Sql,conn,3,3

dim conn,driver,dbpath,rs '建立excel的connection对象 set conn = server.createobject("adodb.connection") driver = "driver={microsoft excel driver (*.xls)};" dbpath = "dbq=" & server.mappath( "test.xls" ) '调用open方法打开数据库 conn.open driver & dbpath '设置dsn连接方式 'conn.open "dsn=test" '注意 表名一定要按照 "[表名$]" 格式书写 sql="select * from [sheet1$] where 序号=0" set rs=conn.execute(sql) if rs.eof and rs.bof then response.write "数据未找到!!" else do while not rs.eof response.write rs("书名") rs.movenext loop end if