Re: Issue with reading from Excel

[Meketon, Marc]

Has anyone been able to run the sudoku_excel.mod found on the examples\sql 
directory under windows 10 64bit?

Sent from my mobile

> On Dec 9, 2019, at 11:13 AM, Meketon, Marc via Users list for GLPK (GNU 
> Linear Programming Kit) <address@hidden> wrote:
>
> 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
>