Open Microsoft Access 2003, create a new mdb and click on the "Queries" Object and select "New | Design View" query as shown:
Close the "Show Table" pane:
Right click within the Design view pane and select a "SQL Specific > Pass-Through" query as shown:
Paste the following example Payroll Sumary Report or your own sp_report into the pane:
sp_report PayrollSummary show Label, AmountHours, AmountRate, Amount parameters DateMacro = 'ThisQuarterToDate' where RowType='DataRow'
and right click on the (blue) Title bar and select "Properties" to setup the connection parameters:
Change the "ODBC Connect Str" to call QODBC like this:
ODBC;DSN=QuickBooks Data;SERVER=QODBC
and open the pass-through query to see the end result!
|