Re: [Help-glpk] reading Excel table into GLPK

[Andrew Makhorin]

> I am a graduate student who is learning GLPK for a project. Right now
> I am practicing reading Excel tables into  GLPK. I am getting an error
> that says “the system cannot find the file specified.” I have put the
> excel file in the same directory as glpsol.exe.  I have successfully
> read this same problem by using text files. The command  I typed in
> was 
> 
> Glpsol  --math diet.mod table food IN “ODBC” “diet.xls”: FOOD <-
> [FOOD], cost, f-min, f_max
> 
> ( If this file looks familiar I am using a sample problem from AMPL
> to  get practice with GLPK before I use the actual model for my
> project.)

You cannot specify the table statement in the command line. It should be 
included into the model description, i.e. into diet.mod.

For details please see the GNU MathProg language reference. See also
some examples in the subdirectory examples/sql. (All these can be found
in the glpk distribution.)