Re: [Help-glpk] Beware of using Access and Excel tables with ODBC (SQL statement) in MathProg

[Andrew Makhorin]

Noli,

> The Excel obdc driver is still problematic compare to sqlite3 and
> Access models.

> I read the AMPL googlegroups archive, they too have problems with
> Excel ODBC. The written result is different from display on screen,
> one user report. Someone is saying he can't write results in Excel
> 2007 and need to write in Access table.

> Just for the record, see the data and solution below. The result of
> excel model is erroneous.

> Based on experience, CSV table is the still the best way to do
> modelling since you can easily use the results in R and Mathplotlib
> for graphs.

You could insert the following statement:

   display I, J, a, b, d, f, c, x;

after the solve statement to see all the input data, intermediate
results, and the solution. Then it would be easy to compare the data
for different runs and find out where the data are distorted.