2,462
社区成员
发帖
与我相关
我的任务
分享
Dim cnn As New Connection
Dim rs As New Recordset
Dim sql As String
Dim qx As String
cnn.Open "Provider=Microsoft.Jet.Oledb.4.0;data Source=" & ThisWorkbook.Path & "\数据库.mdb"
sql = "SELECT 区域,sum(iif(新建类型='新址新建900',1,0)) as 新900站点数, _
sum(iif(新建类型='新址新建900',载频数,0)) as 载波数1 _
FROM 宏站 group by 区域"
rs.Open sql, cnn
'复制字段名
For i = 1 To rs.Fields.Count
Cells(1, i) = rs.Fields(i - 1).Name
Next i
'复制全部数据
Range("A2").CopyFromRecordset rs
rs.Close
cnn.Close
'不能这样换行
sql = "SELECT 区域,sum(iif(新建类型='新址新建900',1,0)) as 新900站点数, _
sum(iif(新建类型='新址新建900',载频数,0)) as 载波数1 _
FROM 宏站 group by 区域"
'只能这样换
sql = "SELECT 区域,sum(iif(新建类型='新址新建900',1,0)) as 新900站点数," & _
"sum(iif(新建类型='新址新建900',载频数,0)) as 载波数1 " & _
"FROM 宏站 group by 区域"
ssql = "INSERT INTO [201108(1-30)] VALUES ('" & arr(y, 1) & " ','" & arr(y, 2) & " ','" & arr _
(y, 3) & " ','" & arr(y, 4) & " ','" & arr(y, 5) & " ','" & arr(y, 6) & " ','" & arr(y, 7) & " ','" & arr _
(y, 8) & " ','" & arr(y, 9) & " ','" & arr(y, 10) & " ','" & arr(y, 11) & " ','" & arr(y, 12) & " ','" & arr _
(y, 13) & " ','" & arr(y, 14) & " ','" & arr(y, 15) & " ','" & arr(y, 16) & " ','" & arr(y, 17) & " ','" & arr _
(y, 18) & " ','" & arr(y, 19) & " ','" & arr(y, 20) & " ','" & arr(y, 21) & " ','" & arr(y, 22) & " ','" & arr _
(y, 23) & " ','" & arr(y, 24) & " ','" & arr(y, 25) & " ','" & arr(y, 26) & " ','" & arr(y, 27) & " ','" & arr _
(y, 28) & " ','" & arr(y, 29) & " ','" & arr(y, 30) & " ','" & arr(y, 31) & " ','" & arr(y, 32) & " ','" & arr _
(y, 33) & " ','" & arr(y, 34) & " ','" & arr(y, 35) & " ','" & arr(y, 36) & " ','" & arr(y, 37) & " ')"