Heinrich, I downloaded glpk-4.55 and unzipped the directory. I copied the 64bit glpsol executable and the "glpk_4_55.dll" and pasted them in Gusek directory. And it works :-)
Andrew, I tested SolverStudio for other Operation Research problems. It's seems a very good application, I liked it and I will use it for problems with fixed data. But with this problem, my tables on Excel are not always identical. The size always changes (and is updated by someone else on my Dropbox). So, I prefer to enter (or let other people enter) the data in the Excel tables and call them with Gusek IDE via instruction "table IN". Thank you for developping SolverStudio, Thanks for your help guys :-) Haroune. ----- Mail original ----- De: "Heinrich Schuchardt" <[email protected]> À: "Haroune ZAGHDAOUI" <[email protected]> Cc: "Help Glpk" <[email protected]> Envoyé: Mardi 25 Novembre 2014 10:55:29 Objet: Re: [Help-glpk] ODBC Excel driver Hello Haroune, a 64bit glpsol executable is available at http://winglpk.sf.net Best regards Heinrich Schuchardt http://www.xypron.de Am 25.11.14 um 09:34 schrieb Haroune ZAGHDAOUI > Hello Heinrich, > > > > Thank you for your help. I uninstalled Excel x64, installed the 32bit ODBC > driver for Excel and it works. I have to find a way to the 32bit Excel > version. > > I heard there is another way : starting the 32bit glpsol executable in x64 > manually by calling it via the Windows command prompt, is it true? If it's > the case, I would like to try to do it. > > > > Thanks again, > > Haroune. > > > > ----- Mail original ----- > > De: "Heinrich Schuchardt" <[email protected]> > > À: "Haroune ZAGHDAOUI" <[email protected]>, "Help Glpk" > <[email protected]> > > Envoyé: Lundi 24 Novembre 2014 17:05:31 > > Objet: Re: [Help-glpk] ODBC Excel driver > > > > 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
