|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Set oRS = Cn.Execute(strSql)
- vRs = oRS.GetRows
- ReDim vData(1 To UBound(vRs, 2) + 1, 1 To UBound(vRs) + 1) '如果要增加数据库字段标题,则(1 To UBound(vRs, 2) + 2, 1 To UBound(vRs) + 1)
- oRS.MoveFirst
- For nRow = 0 To UBound(vRs, 2)
- For nCol = 0 To UBound(vRs)
- 'If nRow = 0 Then vData(1, nCol + 1) = oRS.Fields(nCol).Name '加数据库字段标题
- ' vData(nRow + 2, nCol + 1) = vRs(nCol, nRow) '数据
- ' vData(nRow + 2, nCol + 1) = IIf(IsNull(vData(nRow + 2, nCol + 1)), "", vData(nRow + 2, nCol + 1))'将null转空值
- vData(nRow + 1, nCol + 1) = vRs(nCol, nRow) '数据
- vData(nRow + 1, nCol + 1) = IIf(IsNull(vData(nRow + 1, nCol + 1)), "", vData(nRow + 1, nCol + 1))
- Next
- Next
复制代码 |
|