On 27-Oct-2015 11:01 -0500, Roger Harman wrote:
I'm using SQL Workbench for a number of data extractions where I need
to save the results as XLS. I haven't found a way to get the column
text or titles in lieu of the column names. Does anyone know a way
to do this?

Presumably the ODBC Provider/Driver could have an effect on what is provided by the feature being used to "save the results as XLS". Aside from that, the question directed instead to a forum about the client software might be more productive.?

Yet aside from what is provided by a combination of any particular feature of the client utility and the chosen driver [thus probably not of any direct interest, not of much value, with regard to resolving the issue], there is also the availability, separately, of a query of the catalogs that could provide the desired data; e.g. for the data from SYSCOLUMNS, for the list of columns of a /file/ from which the data is being extracted, the following expression might yield the desirable information [though possibly instead, the first two arguments in reverse order]:
COALESCE(COLUMN_TEXT, COLUMN_HEADING, COLUMN_NAME)


This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].