how to get Excel report from Access

[Guest]

I have a weekly statistics report that comes out in Excel. It has some
historical data and the user has to do vlookups to compare with last weeks to
find missing data. It would be much better in Access. What I want to know
is should I figure out how to do the structure how do you get the report in
Excel. I don't want it in Access report tools. I need it in Excel. Do you
have to write VBA code to print it? Can you explain how it could be
automated once I have the data in access?

thanks,

 

[John Nurick]

Hi Janis,

Access can import simple tabular data to Excel with ease. Exporting an
Access report to Excel tends to preserve the data but lose a lot of
the layout and formatting. If you need to create properly formatted
report in Excel from Access you'll have to write VBA code. (By
'formatted' I mean stuff like headers and footers, subtotals, cell
formatting.)

If you're an Excel wiz it may be simpler (and less coding) to create
an Excel template that pulls the necessary data from Access.

Either way, you set up queries in Access that return the data you
need, and use either VBA code or Excel database functions to get the
values into the right ranges in the workbook.

If you have more questions, post back with some more informatoin about
your data.