Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 53
Default Exporting data to excel and maintaining info

I am exporting a report (or query) to excel, the headers the query supplies
are non-sense to everyone not involved in building the database. How can I
export to a template with the headers in place and not have them written over
(deleted) by the non-sense headers?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,722
Default Exporting data to excel and maintaining info

Create the headers you want to show on row 1. Then have the report imported
starting on row 2. Hide row 2 (the nonsensical headers).
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"shannon" wrote:

I am exporting a report (or query) to excel, the headers the query supplies
are non-sense to everyone not involved in building the database. How can I
export to a template with the headers in place and not have them written over
(deleted) by the non-sense headers?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,696
Default Exporting data to excel and maintaining info

Easiest way? Export to a new workbook, open your template, and paste rows 2
through bottom...

Otherwise, to export directly to Excel, that would completely depend upon
your method.


"shannon" wrote:

I am exporting a report (or query) to excel, the headers the query supplies
are non-sense to everyone not involved in building the database. How can I
export to a template with the headers in place and not have them written over
(deleted) by the non-sense headers?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 53
Default Exporting data to excel and maintaining info

How do I export starting on row 2?

Thank you

"Luke M" wrote:

Create the headers you want to show on row 1. Then have the report imported
starting on row 2. Hide row 2 (the nonsensical headers).
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"shannon" wrote:

I am exporting a report (or query) to excel, the headers the query supplies
are non-sense to everyone not involved in building the database. How can I
export to a template with the headers in place and not have them written over
(deleted) by the non-sense headers?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maintaining history Data in Excel Rajaraman Excel Worksheet Functions 1 November 18th 08 12:55 AM
Exporting Excel Sheet With Additional Info Added To A Text File SouthernBoy718 Excel Discussion (Misc queries) 1 July 12th 08 05:55 AM
Exporting info from a cell Flint Excel Discussion (Misc queries) 1 January 13th 07 12:25 AM
Exporting work sheet info to envelopes chazcps Excel Discussion (Misc queries) 2 June 27th 06 07:17 PM
Exporting contact info to Outlook 2003 200grandprix Excel Discussion (Misc queries) 0 April 25th 06 08:06 PM


All times are GMT +1. The time now is 09:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"