[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Help-glpk] ODBC Excel driver
From: |
Heinrich Schuchardt |
Subject: |
Re: [Help-glpk] ODBC Excel driver |
Date: |
Tue, 25 Nov 2014 10:55:29 +0100 |
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" <address@hidden>
>
> À: "Haroune ZAGHDAOUI" <address@hidden>, "Help Glpk" <address@hidden>
>
> 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
>
> >
>
> > address@hidden
>
> >
>
> > https://lists.gnu.org/mailman/listinfo/help-glpk