Put form fields in Word forms into an Excel spreadsheet?

G

Guest

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.
 
D

Dave Peterson

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.)
 
G

Guest

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.
 
D

Dave Peterson

Maybe you can use separate files for each set of fields. Then combine all those
files into one???

(or ask if there's a better way in one of the MSWord newsgroups????)
 
S

StevieB

Hi AMG,

Once you have the data in Excel then you will need to get it into
QuickBooks. There is no direct way to import transaction data into
QuickBooks. You will need to look at one of the data import utilities
that are now available on the market. You can find a list of them
here, http://www.marketplace.intuit.com

Disclosure:. I have a financial interest in the company that
distributes one the utilities mentioned in this post.
 
S

StevieB

Hi AMG,

Once you have the data in Excel then you will need to get it into
QuickBooks. There is no direct way to import transaction data into
QuickBooks. You will need to look at one of the data import utilities
that are now available on the market. You can find a list of them
here, http://www.marketplace.intuit.com

Disclosure:. I have a financial interest in the company that
distributes one the utilities mentioned in this post.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to Transfer data from Text Form Fields in MS Word into Excel? 1
Dynamic Excel data into locked Word form 0
pasting time from html 12
From word to Excel? 5
How to Get Filtered Data from SQL server into Microsoft Excel 2007 5
Eliminate blank fields in mail merge from Excel to Word 1
insert an Excel spreadsheet as an appendix in a Word Document 1

Top