一句VB中的SQL语句,望人指点~~~
下面是一段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单元格,这条语句应该怎么改?
希望有好心人不吝赐教。。 --------------------编程问答-------------------- SQL = ("Select * into [;database=" & AccessPath & "]." & AccessTable & " FROM [" & sheet & "$B2:B7]") --------------------编程问答-------------------- --------------------编程问答-------------------- nn
补充:VB , 数据库(包含打印,安装,报表)