GDX to sql server

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

GDX to sql server

Post by srikkanth.madhavan » 1 year ago

Is it possible to push data from GDX file to Microsoft SQL server tables? :roll:

User avatar
Renger
Posts: 219
Joined: 2 years ago

Re: GDX to sql server

Post by Renger » 1 year ago

Hi
I probably would export the data in an excel sheet connected to Microsoft SQL using gdxxrw.
Cheers
Renger

srikkanth.madhavan
User
User
Posts: 3
Joined: 1 year ago

Re: GDX to sql server

Post by srikkanth.madhavan » 1 year ago

Data coming from the GDX files sometimes might exceed the row limit in excel.

srikkanth.madhavan
User
User
Posts: 3
Joined: 1 year ago

Re: GDX to sql server

Post by srikkanth.madhavan » 1 year ago

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: 219
Joined: 2 years ago

Re: GDX to sql server

Post by Renger » 1 year ago

You should first add a connection using the ODBC data administrator in Windows
Renger

Myron Bennett
User
User
Posts: 4
Joined: 7 months ago

Re: GDX to sql server

Post by Myron Bennett » 7 months ago

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

Post Reply