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
|