Get descriptive headers in Excel tables when transferring data

I am doing a lot of queries and like to use the data in a MS Excel table. These Excel tables are used also by non-IT personnel. When transferring the data, the header is taking the field names, which are not very self-explanatory sometimes. Is there any possibility to get the describing text into the header of the columns?

It really depends on the interface that they're using to do your queries. The newly announced IBM DB2 Web Query for System i product does support query results being stored in Excel files. You can find more details about this new product at IMB's Web site.

Dig Deeper on DB2 UDB (universal databases)

How to connect Power BI with SharePoint Here's a step-by-step guide on how to connect Power BI with SharePoint team sites without uploading files, allowing you to export and analyze data much more seamlessly.

In-memory from xVelocity to the memory-optimized columnstore index Robert Sheldon explains the history of in-memory technology from the xVelocity in-memory analysis engine to the memory-optimized columnstore index.

Polish your IT reporting by tinkering with Excel table formatting Admins can manage IT reporting data on things such as vendor support levels in an Excel table, if they can properly format, save and update that data.

Big data buzz gets louder with Apache Hadoop and Hive Apache Hive gives SQL-savvy developers the power to add up complex queries against big data in Windows Azure blobs.

Importing SQL Server data into PowerPivot for Excel Microsoft PowerPivot is designed to give BI capabilities to users who lack IT’s technical know-how. The first step is importing SQL Server data, and you have to know your options.

SQL to update the header records? A SearchOracle.com user asks if SQL can be used to update the header records.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our AS/400 experts

View all AS/400 questions and answers

Get descriptive headers in Excel tables when transferring data

Dig Deeper on DB2 UDB (universal databases)

Related Q&A from Kent Milligan

Choose which column names are returned via ODBC when working with DB2 files

Developing tables in a parent-child relationship in DB2

When is the YES option for 'reuse deleted files' function the best choice?

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Refresh your data center cooling lexicon

Comparing Linux distributions: Red Hat vs. Ubuntu

Get eco-friendly with LEED data center certification

Dig Deeper on DB2 UDB (universal databases)

Related Q&A from Kent Milligan

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.