[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 PowerPoint
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 worksheet to the most current data in the linked QuickBooks table.
Before using the 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 clicking next, Please specify the connection string by clicking the "Build" button:
Select DSN "QuickBooks Data" from the DSN list.
Now you will get Connection String to build automatically.
Please click the Next button.
The first time you use MS Excel to access QuickBooks, you will be asked to grant access permission for this application:
Select the "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 PowerPoint tutorial