We have a department with some fairly complex reports that are generated
using Access, Excel and Word. Originally I'd hoped to move them to Reporting
Services, but they add analysis and commentary to the reports so they'll need
them in word or RTF format. Since they do these reports manually, they are
time intensive and subject to error. I'm trying to figure out how to automate
them.


Their current process is to run Access queries, export them manually to
Excel spreadsheets, and then cut and paste the tables and related graphs to a
report.

I've tested using automation to export the query results from Access
(CopyFromRecordset) to Excel. I'm trying to decide how to automate the
insertion of the tables and graphs to the Word document. I've set up a
tempate with bookmarks. I'm not sure if I should try exporting to these, or
try to either embed/link the spreadsheets in the template. Any
recommendations?

thanks
Peter