Knowledgebase: TroubleShooting
[QODBC-Desktop] Troubleshooting - Wrong Data in Excel from QODBC
Posted by Jack - QODBC Support on 10 November 2014 02:25 PM

Problem Description:

We modified an invoice in QuickBooks, and we are trying to get the data out in Excel, but QODBC gives us the old data still.



QODBC failed to return full records is usually caused by corruption of the QODBC optimizer file. I would like to inform you that the Optimizer file may be corrupted if you are killing the process or query while the optimizer file is building. It is not advisable to kill a query while it is in execution.

Please reset the optimizer to solve the problem.

1) Close all other applications that use QODBC.

2) Turn off QODBC optimizer (QODBC Setup Screen->”Optimizer” tab->Uncheck “Use optimizer” option)

3) Find the file with the .opt extension at the path you had assigned to the QODBC optimizer and delete the optimizer file.

(The default path is %AppData%\QODBC Driver for QuickBooks\Optimizer)

You can find the optimizer folder path from QODBC Setup Screen->”Optimizer” tab. Please copy this path & navigate to this path & delete the .opt file.


You can directly delete the .opt file from:

Start>>All Programs>> QODBC Driver for use with QuickBooks>>QODBC Setup Screen>>”Optimizer” tab>>Click "Reset Optimizer File(s)".


4) Turn on QODBC optimizer (QODBC Setup Screen->”Optimizer” tab->Check “Use optimizer” option)

5) After turning on the optimizer, please run the below command in QODBC Test Tool:

sp_optimizefullsync All

This command will bring some data to a local cache to increase retrieval performance for queries. I would like to suggest you, please let run the above command completely. The above command may take some time depends on your records in QuickBooks. It may take 2-24 hours or more depends on the number of records in the QuickBooks company file. Please let this command run completely. Do not kill this command. It is not advisable to kill/close the application while it's building the Optimizer file.

6) Please test again to see if the problem is still there.

7) After completing the above steps, please test data from QODBC Test Tool. If you are able to get updated data, then please refresh the Excel sheet so you can get updated data.

(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).