How to sync with word documents from Access database
Posted on 2011-02-11
Hello, I have an associate that would like to populate an Access database (with data and also with backend forms/controls/VB, reports) and either create (from scratch) or populate (using templates of some sort?) microsoft word documents (not Access reports, actual word docs) that contain slices of the data.
I undertook a similar task several years ago, accessed the Word API from VB to generate word documents in memory and then save them to disk. This was very slow, and the wrong choice. I'm sure there have been evolutions in interoperability since then, I'm just out of touch.
Anyway, since I chose wrong previously and didn't know till the end, thought I'd ask first: can anyone recommend an approach to this?
(We are in the middle of migrating, but I think we want to assume the Office 2007 suite.)
Thanks very much in advance.