dim conn as connection dim rs as Recordset set conn=new connection set rs=new Recordset conn.CursorLocation=adUseClient conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=你的Excel文件名;User ID=Admin;Password=;Extended properties=Excel 5.0" conn.Open rs.open "Select * from 你的Sheet名称",conn rs.RecordCount就是你要的行数。
dim rs as Recordset
set conn=new connection
set rs=new Recordset
conn.CursorLocation=adUseClient
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=你的Excel文件名;User ID=Admin;Password=;Extended properties=Excel 5.0"
conn.Open
rs.open "Select * from 你的Sheet名称",conn
rs.RecordCount就是你要的行数。