Microsoft Office Forums

Go Back   Microsoft Office Forums > >

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

Hi,



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
  #2  
Old 03-17-2017, 03:47 PM
macropod's Avatar
macropod macropod is offline Word & Excel 2010 - Best Options To Auto Insert MySQL & Excel Data? Windows 7 64bit Word & Excel 2010 - Best Options To Auto Insert MySQL & Excel Data? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,761
macropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud ofmacropod has much to be proud of
Default

Mailmerge is certainly a possibility, as it can handle memo data fields. A mailmerge, however, can only handle one data source at a time. Even that could be worked around using one or more DATABASE fields in the mailmerge main document to extract data from the secondary source.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word & Excel 2010 - Best Options To Auto Insert MySQL & Excel Data? Check boxes that insert data from Excel spc94 Word VBA 1 06-22-2015 01:46 PM
Populate Word Drop-down list with Excel column then auto fill form fields with Excel data Faldinio Word VBA 7 10-19-2014 06:03 AM
Word 2010 Field widths from linked Excel data. DPB Word 1 06-25-2014 09:31 PM
Word & Excel 2010 - Best Options To Auto Insert MySQL & Excel Data? saving data in excel 2010 from excel 2003 johnkcalg Excel 1 02-06-2012 07:33 PM
Word & Excel 2010 - Best Options To Auto Insert MySQL & Excel Data? word insert data into excel elemental Word 1 04-29-2011 06:33 PM


All times are GMT -7. The time now is 11:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft