[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Help-glpk] field missing in input table + instruction table
From: |
Heinrich Schuchardt |
Subject: |
Re: [Help-glpk] field missing in input table + instruction table |
Date: |
Fri, 5 Dec 2014 13:22:28 +0100 |
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
>
> address@hidden
>
> https://lists.gnu.org/mailman/listinfo/help-glpk