未引用 activex data objects 2.0 Sub 查询() dim con,sql$ set con=createobject("adodb.connection") conn.open "dsn=excel files;dbq=" & ThisWorkbook.FullName ***** sql语句***** activesheet.[a1].copyfromrecordset con.execute(sql) con.close set con=nothing end sub I