[QODBC-Desktop] How to Use QODBC with MS Excel PowerPivot
Posted by Rajendra Dewani (QODBC Support) on 25 November 2013 10:46 AM
Setup QODBC to work with Microsoft Excel PowerPivot
Note: 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 PowerPivot application, please make sure you have installed MS Excel Add-in named "PowerPivot".
Please select PowerPivot Window.
Please select the data input method via From Other Sources->.
And then in the "Connect to a Data Source" Window, please select Others(OLEDB/ODBC).
After click next, Please specify the connection string by clicking "Build" button:
Select DSN "QuickBooks Data" from the DSN list.
Now you will get Connection String build automatically.
Please click Next button
The first time use of MS Excel to access QuickBooks, you will be asked to grant access permission for this application:
Select "Yes, Always" option, and then click "Done" in the next window:
Choose How to Import The Data.(Choose the second option "Write a query that will specify the data to import")
Write a SQL Statement that will specify the data to import.
Return Data to Microsoft Office Excel PowerPivot will directly export the data to PowerPivot, you can view and edit these records, but modification will not be uploaded.
Keywords: excel 2010 powerpivot tutorial