Excel的VBA连接数据库方法
摘要:
Sub GetData() Dim strConn As String, strSQL As String Dim conn As ADODB.Connection Dim ds As ADODB.Recordset Dim col As Integer '清空电子表格的所有数据 Cells.Clear '连接数据库的字符串 strConn = "Provider=SQLOLEDB.1;... 阅读全文
posted @ 2010-06-01 12:48 章术 阅读(2178) 评论(0) 推荐(0) 编辑