I keep getting this message when I use QODBC.  I use QODBC to insert and update lists in Quickbooks.  I am using Quickbooks Pro 2007, QODBC 8.0 and MS Access 2002 SP3.

I am starting a new company in Quickbooks Pro 2007.  This is a brand new data base with no transactions.  I use Quickbooks import feature to copy my customer list from another database.  However it does not copy the customfields and the notes are truncated at 255 digits.  I am attempting to import these items using QODBC.

QODBC generally imports the first customs fields without problem.  But when I try to import other fields and the notes I get the "error parsing complete xml" kiss of death.

Here is my MS Access SQL command: 

UPDATE CustomerToyCorp INNER JOIN Query1 ON CustomerToyCorp.Name = Query1.Name SET CustomerToyCorp.CustomFieldBirthday = Query1!CustomFieldBirthday, CustomerToyCorp.CustomFieldLastVisit = Query1!CustomFieldLastVisit, CustomerToyCorp.CustomFieldListID = Query1!ListID, CustomerToyCorp.CustomFieldNoOfVisits = Query1!Count;

I shouldn't need a where statement if I am doing it for all records.  I could try 'where Query1!Count is not null' if that would help.

I was able to finally get it to work.  Instead of importing into QB 2007 Pro from Excel, I inserted the customer data from Access.  I then updated it the Customer Notes and then updated the Custom Fields.