1. '前期绑定
    2. microsoft activex data objects 6.1 library
    3. Sub excel_vba_shujuku()
    4. Dim cn As New ADODB.Connection, rs As New ADODB.Recordset
    5. Dim strcn As String
    6. Dim mysql As String
    7. Dim sl As New Dictionary
    8. Sheet2.Range("a1").CurrentRegion.Clear
    9. '连接数据库
    10. strcn = "Provider=sqloledb;Server=LAPTOP-FH2KUPM3;" & _
    11. "Database=数据库练习_表;Integrated Security=SSPI;" & _
    12. "Persist Security Info=False;"
    13. cn.Open strcn
    14. '编辑并连接SQL语句
    15. mysql = "select * from 贫困户信息查询总"
    16. rs.Open mysql, cn
    17. '数据输出
    18. '2、输出数据
    19. '①循环输出标题
    20. For i = 0 To rs.Fields.Count - 1
    21. Sheet2.Cells(1, i + 1).Value = rs.Fields(i).Name
    22. Next i
    23. '②复制输出数据
    24. Sheet2.Range("a2").CopyFromRecordset cn.Execute(mysql)
    25. '③循环输出数据
    26. arr = Application.Transpose(rs.GetRows)
    27. cn.Close
    28. Set cn = Nothing
    29. End Sub