Page 1 of 1

GDX to sql server

Posted: Tue Jun 20, 2017 11:08 pm
by srikkanth.madhavan
Is it possible to push data from GDX file to Microsoft SQL server tables? :roll:

Re: GDX to sql server

Posted: Fri Jun 23, 2017 11:22 am
by Renger
Hi
I probably would export the data in an excel sheet connected to Microsoft SQL using gdxxrw.
Cheers
Renger

Re: GDX to sql server

Posted: Fri Jun 23, 2017 4:49 pm
by srikkanth.madhavan
Data coming from the GDX files sometimes might exceed the row limit in excel.

Re: GDX to sql server

Posted: Fri Jun 23, 2017 6:36 pm
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."

Re: GDX to sql server

Posted: Mon Jul 24, 2017 10:01 am
by Renger
You should first add a connection using the ODBC data administrator in Windows
Renger

Re: GDX to sql server

Posted: Mon May 07, 2018 1:07 pm
by Myron Bennett
hello, a bit stuck with exporting CSV to gd xviewer file is not displayed even in the spreadsheet data ...