Excel VBA ʵÏÖSQLÊý¾Ý¶ÁÈ¡K3ÈËÔ±ÐÅÏ¢

Private Sub CommandButton1_Click()
Worksheets("Sheet2").Select
    Cells.Select
     Selection.Delete Shift:=xlUp
     Range("A1").Select
'Çå³ýÔÚExcelÖеÄÊý¾Ý,È·±£µ¼ÈëÐÅÏ¢²»³öÏÖÓëÔ­ExcelÊý¾Ý½øÐеþ¼Ó
Dim cnnConnect As Object
Dim rstRecordset As Object
    Columns("A:C").Select
    Range("A1").Activate
    Selection.Delete Shift:=xlToLeft
Set cnnConnect = CreateObject("ADODB.connection")
Set rstRecordset = CreateObject("ADODB.Recordset")
cnnConnect.Open "Provider=SQLOLEDB;" & _
    "Data Source=10.11.1.4;" & _
    "User ID=finWork;Password=finwork;"
rstRecordset.Open _
    Source:="Select code, name, email from hm_employees where status=1", _
    ActiveConnection:=cnnConnect
'½¨Á¢Êý¾Ý¿âÁ¬½Ó,SourceΪÊý¾Ý¿âÊý¾Ý·þÎñÆ÷IP,¼°Á¬½ÓÓû§ÃûÓëÃÜÂë,ÔÚʵÏÖʱȷ±£Óû§¶ÔK3Êý¾Ý¿âÓжÁȡȨÏÞ
With ActiveSheet.QueryTables.Add( _
        Connection:=rstRecordset, _
        Destination:=Range("A1"))
    .Name = "Contact List"
    .FieldNames = True
    .RowNumbers = False
    .FillAdjacentFormulas = False
    .PreserveFormatting = True
    .RefreshOnFileOpen = False
    .BackgroundQuery = True
    .RefreshStyle = xlInsertDeleteCells
    .SavePassword = True
    .SaveData = True
    .AdjustColumnWidth = True
    .RefreshPeriod = 0
    .PreserveColumnInfo = True
    .Refresh BackgroundQuery:=False
End With
'µ¼ÈëK3Êý¾Ýµ½ExcelÖÐ,
Range("A1").Value = "¹¤ºÅ"
Range("B1").Value = "ÐÕÃû"
Range("C1").Value = "Email"
    ActiveWorkbook.Worksheets("Sheet2").QueryTables