$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!