RSS Feed
Knowledgebase : TroubleShooting > Functions
     

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...