View Single Post
Old 03-17-2017, 01:50 PM
Hoser Hoser is offline Windows 7 64bit Office 2010 64bit
Join Date: Mar 2017
Posts: 1
Hoser is on a distinguished road
Default Word & Excel 2010 - Best Options To Auto Insert MySQL & Excel Data?


I'm trying to figure out the best way to merge a TON of data into a custom template in word. The templates are 30-100 pages in length, and certain fields in the word template could have 1-2 pages of information inserted - so need to ensure the data fields can hold a large amount of information. There will likely be more than 100 fields to be filled in in the template as well.

The data would have to come primarily from 2 sources - MySQL (for data that is scraped automatically from numerous data sources on the web to be inserted into both Excel & Word) and excel (which would likely be used in tables, to produce charts, etc - and that would be inserted into Word).

I'm not sure where to begin? It seems like this might be too heavy duty for mail merge? Should I consider incorporating Access 2010 to house the data? I prefer MySQL just because I've used it in the past for web scraping.

Thanks for any help!!
Reply With Quote