Re: Issue with reading from Excel

[Heinrich Schuchardt]

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