How to add transactions to QB using ODBC from access

Question

I know that transactions can be altered using ODBC in access/ excel and it works perfectly. How can I write a whole new transaction from MS access using ODBC.

I want add transactions to;

• Build Assembly
• List item

Inventory Adjustment

This seems accomplish-able if I can correctly add information to fields like "TxnID", "EditSquence" etc.

Thanks!

Answer 1

QuickBooks Enterprise Solutions software comes with ODBC, but it is a read-only connection and does not support adding/updating. There is an addon software called QODBC that uses the QBSDK to support read/write ODBC access to the QuickBooks file in QuickBooks Enterprise, Premier, and Pro versions. You can find more information about the QODBC addon at http://www.qodbc.com/default.htm