TROUBLESHOOTING - [QODBC-ALL] - TROUBLESHOOTING - EXCEL CRASHES WHEN
USING SQL STATEMENT WITH TWO INNER JOINS ALONG WITH UNOPTIMIZED
PROBLEM DESCRIPTION
I am using Microsoft Excel.
I am using the following SQL statement.
SELECT TransferInventoryLin...
HOW TO ADD ADDITIONAL QUOTE (') IN INSERT STATEMENT USING QODBC
PROBLEM DESCRIPTION:
I have exported the customer list from QB, and Now I want to insert
these using the insert query. But some of them fail because of the
apostrophe (').
How to deal with...
Check if the table you are importing has any long fields and exclude
them from the import. Some tables in QuickBooks have fields as long as
4095 characters and cannot fit in a single spreadsheet cell.
An excellent example of this is the InvoiceLine tabl...