Joe,
To me the point is, do you want to present it or analyse the data ?
Presenting (and I assume printing) the report is done in Access.
Analysing requires the data not the formatting, so it's not surprising that
"using the Analyze in MS Excel it does not keep the data in the same
format".

One possibility may be to save the Access report as HTML, then in Excel
DataNew Web Query, with full HTML formatting.

NickHK

"JoeA2006" wrote in message
...
I have developed a database that produces a report made up of many
subreports.
In most cases the data is unrelated, but each subreport relates to the
date
and location on the main report. Is there any way to import this date
into
excel formatted the same way it is in the Access reports. When I export
the
report to excel using the "Analyze in MS Excel" it does not keep the data
in
the same format.
I cannot think of anything but creating a huge macro to import all the
data.
Can that work dynamically or do ranges have to be pre set?