View Full Version : Use excel worksheet for a Report?


Rick Stanich
06-19-2009, 12:49 PM
Can I use an excel worksheet (workbook with 4 sheets) for my access reports instead of redesigning them in access?

It would be a time saver for me if I can, I already have modules within excel to populate the sheets with my data.

GalaxiomAtHome
06-19-2009, 11:16 PM
You can export queries to Excel. However you would need to define the target range which is apparently not supposed to be possible.

However I found this page which recons it can be done.

http://accessblog.net/2006/07/export-to-excel-range.html

Rick Stanich
06-23-2009, 06:14 AM
Thank you!