GDX to sql server

questions about GAMS' tools
Post Reply
srikkanth.madhavan
User
User
Posts: 3
Joined: 6 years ago

GDX to sql server

Post by srikkanth.madhavan »

Is it possible to push data from GDX file to Microsoft SQL server tables? :roll:
User avatar
Renger
Posts: 639
Joined: 7 years ago

Re: GDX to sql server

Post by Renger »

Hi
I probably would export the data in an excel sheet connected to Microsoft SQL using gdxxrw.
Cheers
Renger
____________________________________
Enjoy modeling even more: Read my blog on modeling at The lazy economist
srikkanth.madhavan
User
User
Posts: 3
Joined: 6 years ago

Re: GDX to sql server

Post by srikkanth.madhavan »

Data coming from the GDX files sometimes might exceed the row limit in excel.
srikkanth.madhavan
User
User
Posts: 3
Joined: 6 years ago

Re: GDX to sql server

Post by srikkanth.madhavan »

I was trying to use gdxviewer to export data to MS SQL server from command line, but received the error below.

"Microsoft ODBC Drvier manager Data source name not found and no default driver specified."
User avatar
Renger
Posts: 639
Joined: 7 years ago

Re: GDX to sql server

Post by Renger »

You should first add a connection using the ODBC data administrator in Windows
Renger
____________________________________
Enjoy modeling even more: Read my blog on modeling at The lazy economist
Myron Bennett
User
User
Posts: 4
Joined: 5 years ago

Re: GDX to sql server

Post by Myron Bennett »

hello, a bit stuck with exporting CSV to gd xviewer file is not displayed even in the spreadsheet data ...
Post Reply