how to get Excel report from Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Janis - 30 Jul 2007 02:34 GMT

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,

Reply to this Message

John Nurick - 30 Jul 2007 06:36 GMT

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.

>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
[quoted text clipped - 5 lines]
>
>thanks,

--
John Nurick - Access MVP

Reply to this Message