Pulling data from MS Access 2007 and QuickBooks 2010 using QODBC

  • Thread starter Thread starter shirleym
  • Start date Start date
S

shirleym

using ACCESS 2007 AND QODBC (QB Enterprise 2010 release 7) to prepare
a report -
We are using an sp_report CheckDetail with a cleared status field
and combining with two transaction tables (check and check
expenseline tables).

QuickBooks Crashes when we run a query for greater than 12 months.

# OF RECORDS IN THE CHECK TABLE IS 20k AND CHECK DETAIL TABLE IS 25k

The query is selecting all check transactions within a date range and
printing on one line the columns for cleared status, memo(s), payee,
address, amount, acct, ectera.

We can query for ytd or a 12 month period but when we query greater
than 12 months (would like to query for 4 years worth of data) the
QODBC crashes QB software.

We set our iterator(chunk size) TO 100,000 any suggestions what to do
differently? What info do I need to post here that will help?

I am new to this and would appreciate if anyone has any suggestions.
 
Back
Top