Question: I did something really stupid in the SQL*XL setups, somewhere. The column headings are row headings, and I cant move them back where they belong as column headings.

Answer: You are looking for the transpose option. In the SQL*XL resultset options screen you can set this option. In the corresponding program preferences screen you can save this setting.

Transpose means that you get columns for rows. Each column in Excel contains a row, the column headers will also be placed vertically in Excel as a column. Data from the database will be placed as columns in Excel. This can be handy when you have a lot of columns and not too many rows.

Copyright (C) 1995-2007 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.
sitemap