[QODBC-Desktop] How to Use QODBC with MS Excel Power Query
Posted by Jack - QODBC Support on 30 March 2016 10:04 AM
|
|
How to Use QODBC with MS Excel Power QueryNote: QODBC allows you to quickly merge live QuickBooks data into the cells of your Microsoft Excel worksheets for quick calculations and graphs. The data will retain a live link to QuickBooks, and one click will update the data in the worksheet to the most current data in the linked QuickBooks table. Before using MS Excel Power Query application, please make sure you have installed MS Excel Add-in named "Power Query". Please select Power Query Window. Please select the data input method via From Other Sources & click on From ODBC.
In connection string box write "DSN = QuickBooks Data" & In SQL Statement box write your SQL statement & click on "OK" button. If you have 64-bit MS Excel, then you need use write DSN = QuickBooks Data 64-bit QRemote in the connection string box
Now select "Windows" & "Use my current credentials" option and click on "OK" button.: Now you will get data in Power Query, apply filter & other settings as per your requirement & click on "Close & Load" button.
| |
|