VBA利用ADO操作excel求教

2024-12-21 10:03:07
推荐回答(1个)
回答1:

conn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & ThisWorkbook.FullName & ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1'"
试试