用SQL匯入EXCEL資料表 - Yahoo!奇摩知識+

把mysql的資料抓入excel嗎 開啟巨集 程式碼大致如下 Dim conn01 As New ADODB.Connection Dim cmd01 As New ADODB.Command Dim rst01 As ADODB.Recordset conn01.Open ConnectionString:= "連線的字串 "comm_txt01 = "sql語法" Set cmd01 ...

tw.knowledge.yahoo.com