Code: Select all
$onecho > %commandfile1%
c=DRIVER=Microsoft Excel Driver (*.xls);dbq=%filename%StoreDistances.xls;
Q1=select SOURCE,TARGET,DISTANCE from [Sheet1$]
a1=Distance
X=KoliOptDistances.gdx
$offecho
$call =sql2gms @%commandfile1%
Code: Select all
$onecho > %commandfile1%
c=Driver={Microsoft Text Driver (*.txt; *.csv)};dbq=%filename%PerformanceGamsSourceConstraints.csv;
Q1=select disticnt PRODUCTCODE from [PerformanceGamsSourceConstraints$]
s1=product
X=GamsSource.gdx
$offecho
$call =sql2gms @%commandfile1%
I have this version of GAMS for the licanse purposes. So I cannot update the gams.
DXIO.DLL version:GDX Library Jul 4, 2012 23.9.5 WIN 36376.36401 VS8 x86/MS Windows
ADO version: 6.3
Also note that, I only want to import the data with sql syntax, not to import it as table or one parameter in a single csv by using csv2gms tool.
Thanks in advance.