Re: [Help-glpk] ODBC Excel driver

[Heinrich Schuchardt]

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
> 
> address@hidden
> 
> https://lists.gnu.org/mailman/listinfo/help-glpk