Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
michalaw michalaw is offline
external usenet poster
 
Posts: 3
Default export form data to tab-delimited file?

I'm trying to help a co-worker extract the data from a Word form. She is
running into a problem, because going through the "save data only for forms"
method produces a comma-delimited .txt, and several of her respondents used
commas in completing some of the form fields. So, what is intended to be one
response to one question appears in several columns when we import the .csv
into Excel. It seems to me that the easiest way around this is to have Word
create the .txt file using some other delimiter, like a tab or a vertical
bar. Is there any way to do that?

In a related question, do anyone know of a better way to import multiple
..txt files into Excel than going through the Import Text Wizard for each
indiviudal file?
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I export data in Word form fields into either Excel or Acce shellyd Microsoft Word Help 1 March 20th 08 06:53 AM
Saving Table data in txt format Tab delimited? Can it be done? How Red Tables 5 March 19th 08 09:09 AM
Word Form Field data export shellyd Microsoft Word Help 2 March 18th 08 06:42 AM
Mail Merge - Comma delimited data into table ocbarney Mailmerge 3 August 15th 06 08:12 PM
How can I merge data into a form from the keyboard vs data file? samxtc Mailmerge 1 December 12th 05 04:43 PM


All times are GMT +1. The time now is 04:24 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"