[Help-glpk] Does anyone have experience reading named ranges into GMPL?

[Meketon, Marc]

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.