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?

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?

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?

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?