excel vba中抓取mysql特定資料表的特定欄位的資料

1.先去下載MySQL Connector ODBC




2.安裝好後設定odbc



3.進入EXCEL Visual Basic編輯器 -> 選單上 "工具" 選項 -> "設定引用項目" -> 將 "Microsoft ActiveX Data Objects 2.8 Library" 打勾 -> 確定

4.使用ADODB 連結



Dim oConn As ADODB.Connection

Set oConn = New ADODB.Connection

oConn.Open "DRIVER={MySQL ODBC 5.1 Driver};" & _

"SERVER=127.0.0.1;" & _

"DATABASE=mysql" & _

"USER=user;" & _

"PASSWORD=xxxx;" & _

"Option=3"