Use excel worksheet for a Report? (1 Viewer)

[Rick Stanich]

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.

 

[Galaxiom]

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]

Thank you!