Data from Word forms to Excel or Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a Word form that I would like to distribute to our organization to collect information from staff (e.g., name, title, education, publications, etc. for each staff member). Saving the form data as a .txt doesn't work to import the data into Excel because the information I am collecting includes commas in the sentences, etc. What is the best way to collect information from a wide variety of people without having to copy and paste the responses into a spreadsheet or database?
 
Have you tried using the "Save data only for forms" option found under Tools/Options/Save?

I'm able to save form field data in this format with commas and they aren't treated as a delimiter if I import the data into Excel provided you specify quotes as the text qualifier.

Otherwise, have you heard of XML? ;-)
--
Please post all follow-ups to the newsgroup. Email requests for assistance can not be acknowledged.

~~~~~~~
Beth Melton

Word FAQ: http://mvps.org/word
TechTrax: http://mousetrax.com/techtrax/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cut & Paste in Excel without erasing cell borders? 1
How many fields in Word (Office 2003) can be exported to excel? 2
Preparing a filler form for everyone to use in Word 2007 like in 2 1
Word 2007 how to get data from forms to Excel 1
moving text from MS Word form into a Word template 1
Word or Excel? Office form 1
Collecting Properties Information from Word & Excel 1
Excel Data Source 1

Back
Top