请教!
如下语句
DBConn.CursorLocation = adUseClient
DBConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & Sample1.xls & ";Extended Properties='Excel 8.0;HDR=Yes'"
rsDB.Open "select * from [sheet1$]", DBConn, adOpenStatic, adLockOptimistic
Set VSFlexGrid1.DataSource = rsDB
在VSGrid中只能显示到101行记录,请问这是为什么???谢谢!
如下语句
DBConn.CursorLocation = adUseClient
DBConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & Sample1.xls & ";Extended Properties='Excel 8.0;HDR=Yes'"
rsDB.Open "select * from [sheet1$]", DBConn, adOpenStatic, adLockOptimistic
Set VSFlexGrid1.DataSource = rsDB
在VSGrid中只能显示到101行记录,请问这是为什么???谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货