本帖最后由 cutecpu 于 2021-5-30 14:22 编辑
以下代碼,再注意一下簡繁的部份
我這邊是繁體環境,您到時再改成簡體喔!
Sub demo()
Set conn = CreateObject("adodb.connection")
Set rs = CreateObject("adodb.recordset")
ds = ThisWorkbook.Path & "\
數據源.xlsx"
conn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties='Excel 12.0;HDR=yes';Data Source =" & ds
sql = "select * from [
中西藥$]"
rs.Open sql, conn, 3, 3
If rs.RecordCount <> 0 Then
[a2:e1000].ClearContents
[a2].CopyFromRecordset rs
End If
rs.Close
End Sub
祝順心,南無阿彌陀佛!