Report to Excel Formatting

[stajosa]

Hey dudes & dudesses,
Do you know of any way to keep the Access report formatting when you analyze it with Excel?
I have columns that are grouped together, and I'm curious as to whether you can keep them grouped and have a label and line over the proper columns in the exported Excel sheet. Any ideas?

 

[llkhoutx]

One doesn't export an Access report to Excel. One exports a table or query.

 

[stajosa]

I guess I'm not "one" then.
Unfortunately, I do need to export a report to Excel, per the requirements of the business I'm working with.
It looks like it will be an ugly endeavor.
My question remains... is there a way of doing this?

 

[llkhoutx]

Create the columns name in the query, by preceding the field name with the desired description and a colon, e.g.

Desired Description: FieldName in a query column

FieldName can be a calculation utilizing various fields, a field, or a function.

Note that there are no quotations.

Note also that I corrected spelling errors in my earlier post.