Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-04-2014, 09:10 AM
Aprilhm14 Aprilhm14 is offline Put Word forms into an Access database Windows 7 32bit Put Word forms into an Access database Office 2010 32bit
Novice
Put Word forms into an Access database
 
Join Date: Nov 2014
Posts: 1
Aprilhm14 is on a distinguished road
Default Put Word forms into an Access database

What is the best way to transfer words forms into an Access table?

Ideally I would like to create a script that would loop through a folder, Copy Word Forms and transfer them into an Access table?

Thanks,
Reply With Quote
  #2  
Old 11-06-2014, 10:45 PM
gmayor's Avatar
gmayor gmayor is offline Put Word forms into an Access database Windows 7 64bit Put Word forms into an Access database Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

I have an add-in (currently undergoing a major revision in response to user feedback - but will be published over the weekend) that extracts data from forms and puts it in an Excel worksheet. Excel to Access is a simple step. If that would work for you see http://www.gmayor.com/ExtractDataFromForms.htm.

I also have a similar add-in that takes e-mailed forms from Outlook and puts them in Excel or Access tables. See http://www.gmayor.com/extract_email_data_addin.htm

However if you want help in rolling your own, it would be be necessary first to know whether the forms use Legacy form fields or Content Controls, as both are handled differently. Can we also assume that the table already exists, as that makes things somewhat simpler?
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Tags
forms vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to use an Access Database to merge specified PDF documents into word? bgranzow Mail Merge 3 01-07-2014 09:41 PM
get value from access database in normal line alysolyman Word VBA 0 02-16-2013 12:41 PM
Put Word forms into an Access database get access database path in Word vba marooned Word VBA 2 07-04-2012 06:37 AM
Put Word forms into an Access database How to link a combobox to an access database? Joe Patrick Word 1 10-21-2011 09:01 AM
Excel to lookup Access Database PeterP Excel 1 06-11-2009 12:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:30 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