Giving Word the bird

[NauticalGent]

Hello again Hackcess Junkies,
I have used Google to its limits today, including Tony’s (Uncle Gizmo) specific search engine, but I cannot find a definitive answer on this.
My team has a monthly report in MS Word that has a cover sheet and about 5 embedded Excel spreadsheets with a whole bunch of words in between each spreadsheet. It’s about 6 pages long and can be quite a bear.
As I have slowly brought them from “Excel Darkness” into “Access Light” the last hurdle is duplicate this report. I can generate the individual queries to replicate the spreadsheets but I have not found a way to embed a query into Access. In fact, I have found a few places that state it cannot be done. One site suggested linking the queries to spreadsheets and then embedding those into the word document.
I was able to do that, but there is a problem with the refresh – AND – it’s a lot of moving parts that I was hoping to avoid.
So I guess my question is: Can a query be linked/embedded into a Word document? All three versions are 2010.

 

[plog]

My team has a monthly report in MS Word... the last hurdle is duplicate this report...have not found a way to embed a query into Access...

I'm confused. The desired end result is in Word? Or is it in Access?

My aim would be to recreate this report entirely in Access. That way you double click and your report and all the data is there--no refreshing, no pasting, no nothing--one double click.

Is that not possible?

 

[GaryPanic]

coming in on this - can you not add tables via vba?
its going to be bucket loads of coding and exporting to word v

 

[GaryPanic]

here's a site that might help

http://www.vb-helper.com/howto_access_to_word_table.html

 

[NauticalGent]

For plog: Yes the end state is Word, for a few reasons. The vast majority of this report is verbiage with some data in data sheet view to support what is being said. All all the great things Access can do, word processing is not one of them.

For GaryPanic: I was trying to avoid the heavy VBA but allowed for that eventuality. As seamless as it is for Access to work with Excel and Excel to work with Word, I was hoping there was something simple I was over looking.

Thanks for the link, I will give it a go...