ODBC链接数据源(PQ学习)

链接Excel

driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};driverid=1046;dbq=C:Userssxh1204DesktopPowerQueryPQ学习数据源SQL&PQ.xlsx;dsn=dBASE Files

链接Access

DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:UsersadminDesktop est_pwd.accdb

原文地址:https://www.cnblogs.com/seanhu/p/14067737.html