|
From: | Meketon, Marc |
Subject: | [Help-glpk] Does anyone have experience reading named ranges into GMPL? |
Date: | Fri, 15 Nov 2013 11:31:32 -0600 |
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. |
[Prev in Thread] | Current Thread | [Next in Thread] |