|
From: | Haroune ZAGHDAOUI |
Subject: | [Help-glpk] ODBC Excel driver |
Date: | Mon, 24 Nov 2014 16:06:53 +0100 (CET) |
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;
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.
[Prev in Thread] | Current Thread | [Next in Thread] |