下面是一段VB代码:
Dim db As Database
Dim sheet As String, excelpath As String, AccessPath As String, AccessTable As String
Set db = OpenDatabase(excelpath, True, False, "Excel 5.0")
SQL = ("Select * into [;database=" & AccessPath & "]." & AccessTable & " FROM [" & sheet & "$]")
db.Execute (SQL)
这段代码中的底下这句:
SQL = ("Select * into [;database=" & AccessPath & "]." & AccessTable & " FROM [" & sheet & "$]")
db.Execute (SQL)
如果我想读取的是Sheet1表中的B2~B7单元格,这条语句应该怎么改?希望有好心人不吝赐教。。
Dim db As Database
Dim sheet As String, excelpath As String, AccessPath As String, AccessTable As String
Set db = OpenDatabase(excelpath, True, False, "Excel 5.0")
SQL = ("Select * into [;database=" & AccessPath & "]." & AccessTable & " FROM [" & sheet & "$]")
db.Execute (SQL)
这段代码中的底下这句:
SQL = ("Select * into [;database=" & AccessPath & "]." & AccessTable & " FROM [" & sheet & "$]")
db.Execute (SQL)
如果我想读取的是Sheet1表中的B2~B7单元格,这条语句应该怎么改?希望有好心人不吝赐教。。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货