Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2010
    Posts
    1

    Pulling data from Access 2007 and QuickBooks 2010 using QODBC

    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?

  2. #2
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    I worked with Quickbooks data tables before and it's not a pretty structure - lots and lots of scattered data throughout many tables which looked like a military encryption schematic. Quickbooks/Quicken used to never allow access to their data tables as they wanted to keep it proprietary (but I think they've changed their ways and have publically released an QODBC type of driver to connect to their data tables.) I would search and see if you can find the QODBC driver you mentioned to connect to their data tables but I doubt that's going to help you much since again, the data looks rather encrypted. What I used to do was try to export the data out of Quickbooks and then import it into some kind of 'make-sense' table structure in MSAccess. I was once supplied an ODBC type of driver (or maybe it was called QODBC) from an ex-Quickbooks employee to develop some MSAccess reports a few years back but I haven't a clue if I ever kept it (or wanted to even keep it). It was extremely exhausting deciphering the data in the many, many tables with data that seemed to make no relational sense. Lots of tables with only 1 or 2 fields and almost impossible to create any type of query on unless you really understood their methodology.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Have 3 tables - problem with pulling data for query
    By wulfhund in forum Database Design
    Replies: 2
    Last Post: 08-13-2010, 05:38 AM
  2. Pulling only certain data from tables.
    By stevman22889 in forum Access
    Replies: 2
    Last Post: 07-15-2010, 06:23 PM
  3. 2007 Access DB won't work in 2010 - 64 bit
    By InvGrp in forum Access
    Replies: 2
    Last Post: 07-12-2010, 08:45 AM
  4. MS Access 2007 vs 2010
    By ralphjramirez in forum Access
    Replies: 2
    Last Post: 05-06-2010, 06:30 PM
  5. Syncing Quickbooks and Access
    By nomij in forum Import/Export Data
    Replies: 0
    Last Post: 08-22-2008, 07:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums