Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
AMG
 
Posts: n/a
Default Put form fields in Word forms into an Excel spreadsheet?

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Put form fields in Word forms into an Excel spreadsheet?

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
  #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

  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Put form fields in Word forms into an Excel spreadsheet?

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????)

AMG wrote:

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


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
StevieB
 
Posts: n/a
Default Put form fields in Word forms into an Excel spreadsheet?

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

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing a word document into an excel spreadsheet aganchingco Excel Discussion (Misc queries) 7 October 26th 06 11:39 PM
Pleeze Help! Export Excel data into a form in a Word Doc...this one's tough! duugg Excel Discussion (Misc queries) 1 April 21st 06 02:35 PM
Extract MS Excel Data embedded in MS Word qualityprocess Excel Discussion (Misc queries) 0 April 20th 06 05:52 PM
Extracting info from word and displaying in an excel spreadsheet Drew Excel Discussion (Misc queries) 0 March 7th 05 04:49 AM
Copying an Excel spreadsheet to a Word document KG Excel Discussion (Misc queries) 1 November 28th 04 08:38 PM


All times are GMT +1. The time now is 07:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"