I have used the IBIZ QB integrator from http://www.nsoftware.com

>Chris
>
>Thanks for the info. In case I decide to use a 3rd party control, can you recommend any?
>
>I just need to export this data: the trial balance together with some information in the account file.
>
>Cyril
>
>
>>Cyril - the 3rd party control i use to update/import from QB has an ACCOUNT object (and INVOICE, CUSTOMER, RECEIVEPAYMENT, .... objects). On MANY of the objects there is a REFNUMBER property. But it is NOT on the ACCOUNT object. There is also what they call a REFID number on everything including the ACCOUNT object. Here is their description of both properties.
>>
>>REFNUMBER>
>>
>>Reference number for the transaction.
>>
>>Syntax
>>adjustinventorycontrol.RefNumber[=string]
>>Default Value
>>""
>>
>>Remarks
>>This is the reference number assigned to a transaction. Depending on the type of transaction, it appears in the QuickBooks
>>user interface as Bill Number, Invoice Number, etc.
>>
>>Reference numbers are alphanumeric strings and are not limited to actually being numbers.
>>
>>For some types of transactions, if RefNumber is not assigned, QuickBooks will automatically assign a unique one. Reference
>>numbers should generally be unique, but are not guaranteed to be so. It is recommended that applications generating their own
>>reference numbers take steps to ensure their uniqueness.
>>
>>Data Type
>>String
>>
>>REFID>
>>
>>An alphanumerical identifier generated by the server.
>>
>>Syntax
>>accountcontrol.RefId
>>Default Value
>>""
>>
>>Remarks
>>A RefId is an alphanumerical identifier assigned by the server whenever an object is added to QuickBooks. It is
>>guaranteed to be unique across all objects of the same type.
>>
>>This property is required in Update operations, and not used in Add operations.
>>
>>This property is read-only and not available at design time.
>>
>>Data Type
>>String
>>
>>
>>
>>>I haven't looked at QBXML yet. First seeing if I have to use QBXML or if there is another way.
>>>
>>>In QB I exported the list: Chart of accounts to an IIF file, which I could open in Excel.
>>>
>>>There is a field REFNUM which looks unique. Did a search but couldn't find anything to confirm it.
>>>
>>>Do you know if REFNUM be used as a reference to an account?
>>>
>>>Cyril
>>>
>>>
>>>>I was of the impression that QB prevented you from creating accounts, customers, jobs, classes, etc... with a duplicate name. So your customer names for example had to be unique. Granted in your situation, that doesnt help much if the user changes the account name after previously exporting.
>>>>
>>>>If you are using Intuit's QBXML, each transaction, record, account, class, customer, job, etc... has an internally set QBID value assigned when the data is created in QB. You could use that but i dont believe its available to the QB end-user via an "export to excel" type option.
>>>>
>>>>>Any QB experts here?
>>>>>
>>>>>The data I need is in the trial balance, which I can export to Excel, and from there to my VFP application. Easy enough.
>>>>>
>>>>>When QB is setup to use account numbers, the Excel file includes account numbers. However, in QB the user is not obliged to use account numbers. When they are not used:
>>>>>
>>>>>Next time I import the data into my VFP application, I want it to update the same record in my VFP application. However, without an account number I don't know how to match it up!
>>>>>
>>>>>Is there a way that I can identify the QB account on each line of the trail balance report so my VFP application can handle it correctly?
>>>>>
>>>>>
>>>>>Cyril