jzurich01

I saved an MS Word (Office 2003 SP1 running on XP professional) form as a plain text (.txt) file with the “Save data only for forms” option checked under the options/save tab.

My MS Word form has 138 fields. When I import this file into excel the following happens – 97 data fields fill correctly into cells A1 – CS4, the last 16 data fields are bunched together in cell A2 and the balance of 25 data fields are placed in cells B2 - Y2.

What I want is for all data fields to fill into cells in one row so I can add more form results in the subsequent rows.

I have tried using the Excel ASAP utility (V 3.09) to import the data and get the same result.

I expect some problem may occur when I save the “form data only” as a plain text file from my Word Doc form since I get the same result using the Excel data import option and the ASAP utility. Any suggestions?

cantes903

Hey-

I hope this is what you need.

I think the easiest way to do this is to tell you how I would do it. I'd create a document in Word with a table that has 4 rows with 1 column each. (or however many rows you need). In each row, each item is seperated by a comma. Everything in Word row 1 will be imported into Excel row 1. Word row 2 into Excel row 2...

When you're done with the Word doc click on File, Save as.. Change "Save as type.." to Plain Text (*.txt). Click save. When it asks about text encoding, choose "Other encoding" and in the list choose "US-ASCII". Click ok. You can go ahead and close out Word.

Open a new worksheet in Excel. Click Data, Import External Data, Import Data.
Find your txt doc and click "open". Choose "Delimited" and change the file orgin to "Windows (ANSI). Click next and then choose "comma" for the delimiter. Click next. Then click finish. Then click ok.

You should have all the fields in the correct places.

Did it work?