Sorry, I don’t understand what you mean. What exactly should I be doing? I have all the tables uploaded into MySQL. Now using a database query, totally OUTSIDE of QuickBooks, how would I create a detail list of all the transactions?
The Transaction table is a list of all transactions but it does not contain the key information for the transaction. For example, it has every BILL type transaction with the Accounts Payable side (credit side) of the entry. But if I want to see all the distributions of that bill (all the expenses/debits) related to that BILL, I need to join another table.
I am looking for a single table that has every entry. Does that exist?
The answer is you MUST have the 32-bit drivers installed even if your system is only 64 bit. Once I installed the 32 but drivers, the connection worked fine.