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?