Exporting MS Access Report to Excel Problem

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

Hi All,

I hope someone can help me or at least point me in the right direction.
What I am trying to do is to export a report to Excel for data manipulation.
I create a report based on a temp table that shows product quantities for a
10 week period. The report is dynamic and begins on the first week that
contains a quantity in the DB and moves forward 10 weeks. I generically
call the columns in the tmp table Col1, Col2 ... Col10. Then in the report
I determine the appropriate column headers and fill in the date in the page
header. It all works great.

The problem is when I export to Excel. All the data comes over fine but the
headers do not. The headers for the qty columns are Col1, Col2 etc, the
same as in the tmp table. My question, is there a way I can change the
column headers to match what is in the report and not the table definition?

I was thinking about adding a new field in the tmp table and adding in the
dates then manipulating them in excel. But I am hoping there is an easier
Access solution.

Thanks for any help.

Brian
 
Brian

Is there something you are doing to the data that makes it necessary to
export the report, rather than the underlying data?

More info, please...

Jeff Boyce
<Access MVP>
 
Hi Jeff,

No not to my knowledge. The report is fine as is and my user likes it,
layout and detail. He just wants the ability to have the report exported to
Excel. He wants the ability to do forecasting and likes to change numbers
to see how they will change the bottom line etc. So I am just trying to
give him what he wants. LOL the joy of programming, : ). Thanks for any
help.

Brian
 
So, Brian, my suggestion would be that you keep the report (formatted all
pretty, as the user likes), but also provide an export of the underlying
query to Excel.

But this is JOPO (just one person's opinion).
 
Back
Top