Hello Heinrich, Ok for having just one SELECT per table statement.
About the other question, I know about sudoku example. And I know how to write the instruction. But the problem persists. My first line already contain, of course, the column names. But there is a kind of bug, it's like it's coming from the connection between Gusek and Excel. I joined and example in Gusek with it's file Excel. Could you please test it? You will see that the problem is weird. And as I said in my previous mail, it's easy to fix the problem : move the Excel table table one row down (you will have the 1st row empty...), then you delete the 1st row, then start again the program Gusek : it works! What's the matter? Best regards, Haroune ZAGHDAOUI. ----- Mail original ----- De: "Heinrich Schuchardt" <[email protected]> À: "Haroune ZAGHDAOUI" <[email protected]>, "Help Glpk" <[email protected]> Envoyé: Vendredi 5 Décembre 2014 13:22:28 Objet: Re: [Help-glpk] field missing in input table + instruction table Hello Haroune, you can only have one SELECT per table statement. The first line of your selected Excel sheet or range should contain the column names. See examples/sql/sudoku.xls and sudoku_excel.mod in GLPK for Windows. Best regards Heinrich Schuchardt http://www.xypron.de Am 05.12.14 um 12:29 schrieb Haroune ZAGHDAOUI > Hello everyone! > > > > I need your help please, I have 2 questions : > > > > 1) I got a problem with the instruction table. Sometimes, I don't no why, > when I try to load my Excel tables (via ODBC driver), one of the tables don't > want to be loaded. It says : > > > > > > > > Reading CROP_PARTS... > > Connected to EXCEL 12.00.0000 - .\exemple-format-excel.xlsx > > SELECT * FROM [CROP_PARTS$] > > new-model.mod:73: field CPID missing in input table > > > > The point is that in the same Gusek program, I load different tables. All of > them works except when the program arrive to this table. > > I resolved the problem but it's not a logical manner : I move my table (in > Excel) one row down and I deleted the 1st line and it works! There was > nothing in this line. So I was asking myself if the problem comes when we > change the values in the Excel table and Gusek have a problem to read them > (but it's a weird proposition...)... > > > > 2) Is it possible to load different Excel sheet with the same instruction? I > mean, in order to write this : > > > > > > > > > > > > table TEST1 IN 'ODBC' > > 'DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}; > dbq=.\exemple-excel.xlsx' > > 'SELECT * FROM [Sheet1$]': > > CPID <- [CPID], CPCrop, CPName, CPType; > > > > > > table TEST2 IN 'ODBC' > > 'DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}; > dbq=.\exemple-excel.xlsx' > > 'SELECT * FROM [Sheet2$]': > > LID <- [LID], LName, LType, LAddr, LCity, LZIP, LHours; > > > > > > > > > > ...I would prefer to write something like that : > > > > table TEST IN 'ODBC' > > 'DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}; > dbq=.\exemple-excel.xlsx' > > 'SELECT * FROM [Sheet1$]': CPID <- [CPID], CPCrop, CPName, CPType; > > 'SELECT * FROM [Sheet2$]': LID <- [LID], LName, LType, LAddr, LCity, LZIP, > LHours; > > > > What I need is just to take the data to use them in Gusek for some problems > (Facility Location, VRP,...). I can have about 15 sheets... > > > > Thank you so much for your help. > > > > Yours Sincerly, > > Haroune ZAGHDAOUI > > University of Technology of Troyes > > Engineering of Industrial Systems > > _______________________________________________ > > Help-glpk mailing list > > [email protected] > > https://lists.gnu.org/mailman/listinfo/help-glpk
exemple-format-excel.xlsx
Description: MS-Excel 2007 spreadsheet
Test-help-Gusek.mod
Description: audio/mod
_______________________________________________ Help-glpk mailing list [email protected] https://lists.gnu.org/mailman/listinfo/help-glpk
