|
楼主 |
发表于 2019-1-24 08:33
|
显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
感谢回复,之前发的贴子是查询数据的回显动作,没有写明,现在补上!
Sub CX()
Dim cnn As New ADODB.Connection
Dim myPath As String
Dim SQL As String
Unload MainForm
myPath = ThisWorkbook.Path & "\监控数据.accdb"
Sheets("全网指标").Select
Range("A8:l8").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.SpecialCells(xlCellTypeLastCell, 12).ClearContents
Selection.Clear
cnn.Open "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" & myPath
SQL = "select * from bsc级数据"
Range("a8").CopyFromRecordset cnn.Execute(SQL)
Set cnn = Nothing
End Sub |
|