Excel finds the ODC files, and it can retrieve data from them just fine.
Microsoft Query can also edit the queries no problem.
You see, this data is simulation output that I'm further processing in Excel; the simulator outputs an SQLite database.To do this, select the content in Excel to be used and then either type a "Name" for the selected data in the Name Box just above Column Titles A&B or by going to Formulas-Open DBMS Connection. Alternatively, if you have the DBMS toolbar visible, clicking on the Open DBMS Table icon ( ) will deliver the same "Select One or More Tables to Open" dialog.Choose the Database to use and the relevant Database Table.If you are not sure where your file is located, from within Quick Books, press your F2 button and refer to the “Location” field. (Create credentials in QB, by navigating to Reports / Custom Reporting / Manage ODBC Users.) Do Not Click “OK” yet. Now save and close the Excel file, and then enter a transaction in Quick Books so that your balances change and need to be refreshed. At this point, if I try to open my Excel file and click Refresh, I may see the error message, “[Sybase][ODBC Driver][SQL Anywhere]Specified database not found” (this doesn’t show in ALL situations).This is the first of two key steps – On the Database tab, Once the query is designed, return the data to Microsoft Excel. This occurs because when ODBC is used via Microsoft Query (the underlying connection tool in Excel) the connection is encrypted.
Note that the balances shown in my Excel file match those that were shown in Quick Books. When the Quick Books file is closed and reopened, the encryption changes. Once the file is open, you should be able to refresh with no errors.