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: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr 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

Other Forums: Access Forums

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


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