
	Home > Ask the AS/400 Experts > iSeries Systems Management Questions & Answers > Get descriptive headers in Excel tables when transferring data

Ask The iSeries 400 Expert: Questions & Answers

EMAIL THIS

Get descriptive headers in Excel tables when transferring data

EXPERT RESPONSE FROM: Kent Milligan

		Pose a Question

		Other iSeries 400 Categories

		Meet all iSeries 400 Experts
		Become an Expert for this site

Digg This!

StumbleUpon

Del.icio.us

QUESTION POSED ON: 23 August 2007
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?

EXPERT RESPONSE
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.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	iSeries Systems Management
	HIPER PTF installation and cover letters for SF99097
	Library QUSRSYS not completely installed
	SQL statement history storage
	Setting up an automatic reply in the system reply list
	Clearing physical member file records
	Drive space management commands
	Group PTFs
	i5/OS defect when submitting a CHGPF command to an existing physical file
	How do I retrieve the source for an output queue description to put in to a CL program?
	Is there a way to get and modify the source for QDSIGNON2?

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 1999 - 2008, TechTarget \| Read our Privacy Policy