[Help-glpk] [Fwd: Re: result.xlsx out with GLPK]

[Andrew Makhorin]

-------- Forwarded Message --------
From: Stefan Basus <address@hidden>
To: Andrew Makhorin <address@hidden>
Subject: Re: result.xlsx out with GLPK
Date: Wed, 07 Sep 2011 16:27:14 +0200

-------- Original-Nachricht --------
> Datum: Wed, 07 Sep 2011 16:40:35 +0400
> Von: Andrew Makhorin <address@hidden>
> An: Stefan Basus <address@hidden>
> CC: address@hidden
> Betreff: Re: result.xlsx out with GLPK

> > my name is stefan and I am a student university in halle. I have made a
> >  model for my thesis and currently I dont can allow to get out my dates
> >  as an excel-table. can somebody help me? i used this sytax:
> > 
> > table result {production (i,j,k)} OUT "ODBC" 
> >   'DRIVER={Microsoft Excel Driver (*.xlsx)};dbq=glpk.xlsx'
> >   'DROP TABLE result;'
> >   'CREATE TABLE result (PRODUCT, TRAIN, POSITION);'
> >   'result' :  i~PRODUCT, t~TRAIN, k~POSITION;
> > 
> > 
> > thank you beforehand.
> 
> Please provide the error message reported.
> 
> 

the syntax i did try is:

table result {i in PRODUCTS, j in TRAINS, k in POSITIONS} OUT "iODBC"
'DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, 
*.xlsb);DBQ=.\result.xlsx;READONLY=FALSE'
'INSERT INTO [result$] VALUES (PRODUCTS, TRAINS, POSITIONS)' :
 i ~ PRODUCTS, j ~ TRAINS, k ~ POSITIONS;

if i had run the model, i got this error message:

[...]
Generating indicator2...
Writing result...
Failed to connect

Generating indicator2...
Writing result...
Failed to connect

The driver reported the following diagnostics whilst running SQLDriverConnect
IM012:1:0:[Microsoft][ODBC Driver Manager] DRIVER-Schlüsselwort-Syntaxfehler
schedule.mod:139: error on opening table result
MathProg model processing error
>Exit code: 1    Time: 1.311

i really don´t now, what it is the problem at this syntax!
i become insane. can you help me?

thanks a lot!

best regarts
stefan.