GDX to sql server
-
- User
- Posts: 3
- Joined: 6 years ago
GDX to sql server
Is it possible to push data from GDX file to Microsoft SQL server tables?
Re: GDX to sql server
Hi
I probably would export the data in an excel sheet connected to Microsoft SQL using gdxxrw.
Cheers
Renger
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
Enjoy modeling even more: Read my blog on modeling at The lazy economist
-
- User
- Posts: 3
- Joined: 6 years ago
Re: GDX to sql server
Data coming from the GDX files sometimes might exceed the row limit in excel.
-
- User
- Posts: 3
- Joined: 6 years ago
Re: GDX to sql server
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."
"Microsoft ODBC Drvier manager Data source name not found and no default driver specified."
Re: GDX to sql server
You should first add a connection using the ODBC data administrator in Windows
Renger
Renger
____________________________________
Enjoy modeling even more: Read my blog on modeling at The lazy economist
Enjoy modeling even more: Read my blog on modeling at The lazy economist
-
- User
- Posts: 4
- Joined: 6 years ago
Re: GDX to sql server
hello, a bit stuck with exporting CSV to gd xviewer file is not displayed even in the spreadsheet data ...