Knowledgebase: Tutorials
[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.

Also, Refer :
How to Use QODBC POS with Microsoft Access 2007
Using QuickBooks POS Data with Access 2010 (Import Tables) 32-bit
Using QuickBooks POS Data with Access 2010(Linked Tables) 32-bit
How to Configure QODBC to Work With 64-bit MS Access
Microsoft Access 2003 and QODBC


Keywords: excel 2010 powerpivot tutorial

(4 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).