Text to Excel format problem

[Melee]

I have extracted data from a Lotus application to a word file. There are 19 fields that I want to pull out and put into an Access database. The
information is structured as follows:

FirstName: 1x
Mid_Init: y
Address1:mmmmm
Address2: kkkkkkk
City: Chicago
State: IL
Zip: 33333
Alt_Address1:
etc.
Then the list repeats with the next contact.

I want to use the first part of the info as the header (ie "FirstName" and
"Address1&quot with the right side of the : as the data. Is there a utility
and an easy process to do this? I have about 1000 records to convert.

 

[Storyteller]

Hello,
I would suggest that instead of using Word you use Excel.

There are two ways of doing this:
1. Transpose() function
- look in Help for specifics on how to use this function
2. Paste Special and select "Transpose"
- This is much easier to use than the function

All you have to do is copy the data A1:A19 and then "Paste Special", selecting "Transpose" into C1. Then copy B1:B1000 and "Paste Special", selecting "Transpose" into C2

The reason I suggest "copy" instead of "cut/paste" is that if it doesn't work, you won't have to re-import the file.

Hope this helps,
MO

ps: remember to "clean-up" the data before you import it into Access