The sp_report I need to pull into Access 2007 as a loaded table is as follows:
sp_report CheckDetail show TxnType, TxnID, RefNumber, Date, Name, Account,
OriginalAmount, ClearedStatus parameters DateFrom={d'2007-01-01'}, DateTo={d'2008-06-30'}
Where (TxnType='check') and (ClearedStatus='NotCleared' or ClearedStatus='Cleared')
Is it possible to pull this into an Access 2007 table from QuickBooks? If so can you point me to how to do this?