Re: Issue with reading from Excel

Hello Marc,

which driver are you using?

Your current directory is assumed to be examples\sql.
Did you cd to that directory?

Best regards

Heinrich Schuchardt

http://www.xypron.de

Am 09.12.19 um 16:23 schrieb Meketon, Marc\ via \Users list for GLPK (GNU Linear Programming Kit)

> Hello GLPK’ers
> 
> I’m trying to use GMPL to read from Excel.  Below is essentially from the Sudok_excel.mod example found in the distribution, but where I updated it with a later driver:
> 
> set fields dimen 2;
> param givens{1..9, 1..9}, integer, >= 0, <= 9, default 0;
> /* the "givens" */
> 
> table ti IN 'ODBC'
>   'DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};'
>   'dbq=C:\glpk_463\examples\sql\sudoku.xlsx'
>   'SELECT ID, COL, LIN, VAL FROM [Sudoku$] '
>   'WHERE ID = 1' :
>   fields <- [COL, LIN], givens ~ VAL;
> 
> end;
> 
> ==>When I run this, two problems occur, and help would be appreciated:
> ==>  1.  A window pops up asking me which Excel file to use.  Is there a way to eliminate it?
> ==>  2.  I get the error below.  This is really important to solve.  I have tried both named ranges for the Excel data, and worksheet names (that end with a $).
> 
> GLPSOL: GLPK LP/MIP Solver, v4.57
> Parameter(s) specified in the command line:
>  --cover --clique --gomory --mir -m sudoku_excel.mod
> Reading model section from sudoku_excel.mod...
> 12 lines were read
> Reading ti...
> Connected to EXCEL 12.00.0000 - C:\glpk_463\examples\sql\sudoku.xlsx
> SELECT COL, LIN, VAL FROM WHERE ID = 1
> db_iodbc_open: Query
> "SELECT COL, LIN, VAL FROM WHERE ID = 1"
> failed.
> 
> The driver reported the following diagnostics whilst running SQLExecDirect
> 42000:1:-3506:[Microsoft][ODBC Excel Driver] Syntax error in FROM clause.
> sudoku_excel.mod:5: error on opening table ti
> MathProg model processing error