[QODBC-Desktop] How to create sp_reports using Microsoft Excel 2007
Posted by Juliet (QODBC Support) on 25 July 2011 06:05 AM
How to create sp_reports using Microsoft Excel 2007
To extract sp_reports from QuickBooks into Microsoft Excel Spreadsheet, you should use Microsoft Query.
How to extract sp_reports using Microsoft Excel 2007
Open Microsoft Query in Excel
Note: Make sure you have installed Microsoft Query Add-on first. To know how to install Microsoft Query, please refer to Microsoft Office with MS Query and QODBC
Open Microsoft Excel 2007, get external data from Microsoft Query via Data Menu -> Get External Data -> From Other Sources -> From Microsoft Query as below:
Create a New Microsoft Query in Excel
Select the DSN you want to use to connect to the QuickBooks file.
Note: Uncheck option "Use Query Wizard to Created/edit Queries" since we do not need to import any QuickBooks tables here.
Close the "Add Tables" window by clicking the "Close" button.
Press the "SQL" button to input your sp_report query as below. Here we take a CustomerBalanceDetail report as an example:
Press Execute button to get results in Microsoft Query:
Return Records to Excel Spreadsheet
Select Menu File -> Return Data to Microsoft Office Excel to return records to Excel Spreadsheet.