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