 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
SqlExplorer
Joined: 18 Sep 2011 Posts: 124 Country: United States |
|
Can we configure the Excel export not to convert underscores |
|
Hi,
How do we delete this message? It no longer applies, since it was regarding version 12.
13 might have the same problem, but I want to spend time exploring it, before asking about it.
|
|
Mon Jan 06, 2025 1:47 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
It cannot be customized in Export to Excel, it's a feature designed based on users asking.
An alternative is saving results to a CSV file using Save As... menu and then opening that CSV file in Excel. The CSV file is going to have original column names as returned by the database query.
|
|
Tue Jan 07, 2025 2:28 am |
|
 |
SqlExplorer
Joined: 18 Sep 2011 Posts: 124 Country: United States |
|
|
|
Ok, it's understandable why users would want this to be the default setting. Although it's unusual that they would specifically choose to have no options.
Anyway, thanks, I'll work with it. I can do a quick search & replace, or write a vbscript that converts the spaces to underscores.
 |
 |
It cannot be customized in Export to Excel, it's a feature designed based on users asking.
An alternative is saving results to a CSV file using Save As... menu and then opening that CSV file in Excel. The CSV file is going to have original column names as returned by the database query. |
|
|
Tue Jan 07, 2025 10:06 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|