Description
Store data from Access database (file Transportation.accdb) into a GDX file. This model is referenced in section "Strategies" from the SQL2GMS Documentation. Keywords: SQL2GMS, data exchange, GAMS language features
Category : GAMS Data Utilities library
Main file : SQL2GDX2.gms includes : Transportation.accdb SQL2GDX2.gms
$title Creates a GDX File using SQL2GMS at compile Time (SQL2GDX2,SEQ=056)
$onText
Store data from Access database (file Transportation.accdb) into a GDX file.
This model is referenced in section "Strategies" from the SQL2GMS Documentation.
Keywords: SQL2GMS, data exchange, GAMS language features
$offText
$callTool win32.msappavail Access
$if errorlevel 1 $abort.noError "No Access available"
$onEcho > howToRead.txt
C=DRIVER=Microsoft Access Driver (*.mdb, *.accdb);dbq=.\Transportation.accdb
X=Transportation.gdx
Q1=SELECT name FROM suppliers
S1=i
Q2=SELECT name FROM demandcenters
S2=j
Q3=SELECT name, demand FROM demandcenters
A3=demand
Q4=SELECT name, supply FROM suppliers
A4=supply
Q5=SELECT supplier, demandcenter, distance FROM distances
A5=dist
$offEcho
$call sql2gms.exe @howToRead.txt > %system.nullfile%
$ifE errorLevel<>0 $abort Error using SQL2GMS!