Sub test()
Set cn = CreateObject("adodb.connection")
cn.Open "provider=microsoft.jet.oledb.4.0;extended properties=excel 8.0;data source=" & ThisWorkbook.Path & "\数据文件\辅助工作表.xls"
Sql = "select * from [打卡正式$] "
ThisWorkbook.Sheets(1).[a1].CopyFromRecordset cn.Execute(Sql)
Sql = "select * from [考勤明细$] "
ThisWorkbook.Sheets(2).[a1].CopyFromRecordset cn.Execute(Sql)
cn.Close
End Sub
Set cn = CreateObject("adodb.connection")
cn.Open "provider=microsoft.jet.oledb.4.0;extended properties=excel 8.0;data source=" & ThisWorkbook.Path & "\数据文件\辅助工作表.xls"
Sql = "select * from [打卡正式$] "
ThisWorkbook.Sheets(1).[a1].CopyFromRecordset cn.Execute(Sql)
Sql = "select * from [考勤明细$] "
ThisWorkbook.Sheets(2).[a1].CopyFromRecordset cn.Execute(Sql)
cn.Close
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货