View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
AMG
 
Posts: n/a
Default Put form fields in Word forms into an Excel spreadsheet?

Yes! That works, but for only one line. I don't know how to make the next
set of form fields go into the second line, etc.

"Dave Peterson" wrote:

I've never used this, but someone (I think Debra Dalgleish) once suggested just
saving the data in MSWord.

Inside MSWord (with your document active):
tools|options|Save Tab|Check "Save data only for forms"

From MSWord 2003's help:

Save data only for forms Saves the data entered into an online form as a
single, tab-delimited text file in plain text format. You can then import the
contents of that file into a database for analysis.

It sounds like that's what you want.

(I have no experience with quickbooks.)

AMG wrote:

I have multiple Microsoft Word 2002 forms with the data in form fields. I
would like to convert the data into Excel 2002 so that the data from text1,
text3, etc., are placed in an Excel table with each document's form fields in
a line of Excel. I hope to be able to import the Excel Spreadsheet into
Quickbooks 2005 as invoice data.


--

Dave Peterson