software

I have a form that has a vendor name amp; then 1 to 5 entries. I would like to
import the data to a spreadsheet from several saved forms a couple times a
week. How do I do this? I want the vendor name listed with each entry.
Here is an example of the list that would come from only 2 forms, one for
each vendor:

Vendor ABC $40.00 5252336 1/20/06
Vendor ABC $66.00 4458223 1/22/06
Vendor XYZ $52.55 1112522 1/25/06

This data would come from a Word form saved as data only. The forms would
be like this:

Vendor ABC Vendor XYZ
$40.00 5252336 1/20/06 $52.55 1112522 1/25/06
$66.00 4458223 1/22/06

Any help or insight?????

what is the file name? If it's a text file, excel will open it and start the
text import wizard and you can pick fixed width as the file type.

quot;Bethany Lquot; wrote:

gt; I have a form that has a vendor name amp; then 1 to 5 entries. I would like to
gt; import the data to a spreadsheet from several saved forms a couple times a
gt; week. How do I do this? I want the vendor name listed with each entry.
gt; Here is an example of the list that would come from only 2 forms, one for
gt; each vendor:
gt;
gt; Vendor ABC $40.00 5252336 1/20/06
gt; Vendor ABC $66.00 4458223 1/22/06
gt; Vendor XYZ $52.55 1112522 1/25/06
gt;
gt; This data would come from a Word form saved as data only. The forms would
gt; be like this:
gt;
gt; Vendor ABC Vendor XYZ
gt; $40.00 5252336 1/20/06 $52.55 1112522 1/25/06
gt; $66.00 4458223 1/22/06
gt;
gt; Any help or insight?????