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


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 PowerPoint tutorial

(4 vote(s))
Helpful
Not helpful

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