Import Vertical Text records into Excel?

[RF101]

I have searched extensively but I have been unable to find a PERL script or sample VBA that will do what I want. I may be using the wrong terminology.

I have a lot of text based reports in the following format:

date 03/06/2008
time 08:00
release 19.0
script_ver 3
omc_id 1230
mm_id 12301
mm_type 2-way PUMA R12000 MM
paging_mode UDP
att 18032
moa 8953
mta 9079
cc 14525

The records are a set length and repeat. I am looking for a way to grab this data and transpose it so that it is easier to use in excel or access.

Like this:

Date Time Release Etc...
03/06/2008 08:00 19.0

Any help would be greatly appreciated.

Thanks,

RF101

 

[ck1999]

Have you looked at importing text files or tab deliminated files?

ck1999

 

[combo]

If the length of horizontal database exceeds relatively low number of columns you will not be able to import the whole dataset. In this case I would consider reading rows and next use Split function to get single values (if specific character exists) and loop to fill worksheet.

combo