Results 1 to 4 of 4

QODBC Quickbooks online table naming convention

  1. #1
    mcucino is offline Advanced Beginner
    Windows 8 Access 2016
    Join Date
    Jul 2017
    Location
    Providence, RI
    Posts
    71

    QODBC Quickbooks online table naming convention

    Hello all, I am working with a QODBC data source from quickbooks online. I am getting an "invalid table name" error when trying to run a simple query. I think it's something to do with a prefix (like dbo_tablename) but I can't find the information anywhere on the entirety of the world wide web. Any suggestions?

    Code:
    select * from account;
    ...produces error 11025 "invalid table name"

  2. #2
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    7,570
    found this easily enough

    https://http-download.intuit.com/htt...ationGuide.pdf

    from page 4, looks like
    List Tables: have _v_lst_(list name) in the table name.Such as _v_lst_customer
    Transaction Tables: have _v_txn_(transaction type) in the table name.Such as _v_txn_check_line

  3. #3
    mcucino is offline Advanced Beginner
    Windows 8 Access 2016
    Join Date
    Jul 2017
    Location
    Providence, RI
    Posts
    71
    Yes, I found that file as well. I think it's specific to Quickbooks desktop, though. Quickbooks online has a surprisingly different structure in a lot of places. I tried it anyway, just in case, same error.

    Code:
    select * from _v_lst_account;

  4. #4
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    7,570
    did you read the whole file? - look further down - tables may be in a domain. Also, per the example have you tried importing a table? that will display the domain.

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

Similar Threads

  1. The PK and FK field naming convention....
    By DBID10T in forum Database Design
    Replies: 6
    Last Post: 10-25-2019, 05:49 AM
  2. Naming convention question? btn or cmd?
    By RLehrbass in forum Access
    Replies: 7
    Last Post: 09-21-2015, 07:51 PM
  3. Anyone use QODBC for Quickbooks?
    By Xipooo in forum Access
    Replies: 17
    Last Post: 08-17-2015, 12:10 PM
  4. Access to Quickbooks Connection: QODBC
    By davibus in forum Access
    Replies: 1
    Last Post: 09-09-2014, 03:10 PM
  5. Replies: 1
    Last Post: 08-22-2010, 12:25 PM

Posting Permissions

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