Hi,
I am trying to read into GMPL a named range from Excel. "distances" is a named
range in Excel, with a column called "FromNode". I am getting a syntax error
("42000:1:-3506:[Microsoft][ODBC Excel Driver] Syntax error in FROM clause.") .
Any help would be appreciated.
The code looks like:
set NODE;
table distances IN 'ODBC'
'DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};'
'dbq=C:\\BNSC.xlsx'
'SELECT FromNode FROM distances' :
NODE <- [FromNode];
display NODE;
________________________________
This e-mail and any attachments may be confidential or legally privileged. If
you received this message in error or are not the intended recipient, you
should destroy the e-mail message and any attachments or copies, and you are
prohibited from retaining, distributing, disclosing or using any information
contained herein. Please inform us of the erroneous delivery by return e-mail.
Thank you for your cooperation.
_______________________________________________
Help-glpk mailing list
[email protected]
https://lists.gnu.org/mailman/listinfo/help-glpk
