Hello Haroune, Gusek comes with the 32bit glpsol executable. You need a 32bit ODBC driver for Excel (not X64).
Best regards Heinrich Schuchardt http://www.xypron.de Am 24.11.14 um 16:06 schrieb Haroune ZAGHDAOUI > Hello everyone, > > > > I need your help please : > > I have an Excel table where I put my data in columns. Then I wrote a gusek > program to get this data through via ODBC. If I register my Excel file as an > Excel from 97-2003, and I write the following instruction, it works : > > > > > > table LOCATIONS IN 'ODBC' > > 'DRIVER={Microsoft Excel Driver (*.xls)};dbq=.\exemple-format-excel.xls' > > 'SELECT * FROM [LOCATIONS$]': > > LID <- [LID], LName, LType, LLon, LLat, LAddr, LCity, LZIP; > > > > > > > > > > But if my Excel file is from 2010 (as my Excel version), it says that there > is a problem with the driver : > > > > > > > > > > Program : > > > > > > > > > > table LOCATIONS IN 'ODBC' > > 'DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb) > };dbq=.\exemple-format-excel. xlsx ' > > 'SELECT * FROM [LOCATIONS$]': > > LID <- [LID], LName, LType, LLon, LLat, LAddr, LCity, LZIP; > > > > Here is the message error : > > > > > > > > GLPSOL: GLPK LP/MIP Solver, v4.55 > > Parameter(s) specified in the command line: > > --cover --clique --gomory --mir -m test-locations.mod > > Reading model section from test-locations.mod... > > 20 lines were read > > Reading LOCATIONS... > > Failed to connect > > > > The driver reported the following diagnostics whilst running SQLDriverConnect > > IM002:1:0:[Microsoft][Gestionnaire de pilotes ODBC] Source de données > introuvable et nom de pilote non spécifié > > test-locations.mod:12: error on opening table LOCATIONS > > MathProg model processing error > > > > > > > > > > I really don't know where does the problem come from : I downloaded the Excel > driver from Microsoft website (AccessDatabaseEngine_X64) but it still doesn't > work. > > > > > > > > > > Thank you so much for your help. > > > > > > > > > > Yours Sincerly, > > > > Haroune. > > University of Technology of Troyes > > Engineering of Industrial Systems > > > > _______________________________________________ > > Help-glpk mailing list > > [email protected] > > https://lists.gnu.org/mailman/listinfo/help-glpk _______________________________________________ Help-glpk mailing list [email protected] https://lists.gnu.org/mailman/listinfo/help-glpk
