-------- Forwarded Message -------- From: Stefan Basus <[email protected]> To: Andrew Makhorin <[email protected]> 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 <[email protected]> > An: Stefan Basus <[email protected]> > CC: [email protected] > 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. _______________________________________________ Help-glpk mailing list [email protected] https://lists.gnu.org/mailman/listinfo/help-glpk
