Failure when attempting to import data into the QBOE Customer table.  We have constructed a local customer table within Microsoft Access 2000.  The structure of this table matches the QBOE Customer table.  We are using an update query to add records to the QBOE Customer table from the local access customer table.  Either the process fails after accepting 1 record or the following error message is returned "Error Parsing Complete XML return string #10052".  The following is a copy of the SQL statement used

UPDATE [QB Customer], Customer SET Customer.Name = [QB Customer].[Name], Customer.BillAddressAddr1 = [qb customer].[billaddressaddr1], Customer.BillAddressAddr2 = [qb customer].[billaddressaddr2], Customer.BillAddressCity = [qb customer].[billaddresscity], Customer.BillAddressState = [qb customer].[billaddressstate], Customer.BillAddressPostalCode = [qb customer].[BillAddressPostalCode], Customer.Phone = [qb customer].[phone], Customer.AltPhone = [qb customer].[altphone];

Could someone please tell us what we are doing incorrectly. 

Thank You.

Sorry, the UPDATE command is used to change existing records, not create them. See: How do I update Customer custom fields? for an example of creating a new customer and updating the customer later on. When using the QuickBooks Online Edition (QBOE) the ListIDs are small numbers starting from 1.

In Access you will need to use VBA to create a module that loops through your dataset creating QODBC insert statements.

See: VB Script Performance importing from SQL Server to QuickBooks for an example.