Hello Christina,
please, refer to the GLPK Wiki
<http://en.wikibooks.org/wiki/GLPK/ODBC#Microsoft_Excel>.
> 'DRIVER={Microsoft Excel Driver (*.xlsm)}; dbq=RGHtemplate.xlsm'
You are using a driver name that does probably does not exist.
If you want to read Office 2007 or 2010 Excel files you have to specify
the following ODBC driver:
DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)
DRIVER={Microsoft Excel Driver (*.xls)}
is for Office 2003 only as indicated in examples/sudoku_excel.mod of
GLPK for Windows <http://winglpk.sourceforge.net/>.
This may require to download the appropriate driver first, e.g. one of
2007 Office System Driver: Data Connectivity Components
Microsoft Office Access Runtime and Data Connectivity 2007 Service Pack
2 (SP2)
Microsoft Access Database Engine 2010 Redistributable
Both a 32bit and a 64bit version of"Microsoft Access Database Engine
2010 Redistributable" are available. The version that matches the GLPK
library used is required.
Best regards
Xypron
CHRISTINA CIGNARALE (RIT Student) wrote:
Hi,
I am using the current version of GLPK and have been referencing the
sodoku_odbc.mod example for my own project. I recently changed my
setup of reading each set of data from a different excel workbook to
one workbook where each set has a sheet. The sheets are populated from
a template sheet. I wrote some macros to transfer the data from the
template to the appropriate sheet. I now have a problem with the ODBC
handler. It will not accept the *.xlsm extension. Does anyone have any
suggestions for fixing this? I get an error from the first table
statement.
Thank you for your help.
Christina Cignarale
Industrial & Systems Engineer
Rochester Institute of Technology
_______________________________________________
Help-glpk mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/help-glpk
