ODBC链接数据源(PQ学习)


链接Excel

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

链接Access

DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\Users\admin\Desktop\test_pwd.accdb