RE: Issue with reading from Excel

[Meketon, Marc]

Forgot to CC the mailing list.

-----Original Message-----
From: Meketon, Marc
Sent: Monday, December 9, 2019 11:04 AM
To: Heinrich Schuchardt <address@hidden>
Subject: RE: Issue with reading from Excel

Thank you for your quick reply.

I'm running on Windows 10, 64bit.  The message did not seem like it was a 
driver issue.  The error says:  Syntax error in FROM clause

I did not CD to the directory because I listed the full path 
(dbq=C:\glpk_463\examples\sql\sudoku.xlsx)

-----Original Message-----
From: Heinrich Schuchardt <address@hidden>
Sent: Monday, December 9, 2019 10:59 AM
To: Meketon, Marc <address@hidden>; address@hidden
Subject: 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