reading from a text file and writing to a news text file

[Needhelp2]

Hi all,

I have a large txt file (3 Million lines). Ouside excel capacity.
Thanks for your support...

input file format:

..
...
...
2014 Jul 23 08:15:16.675
...
..

Name = x
Lastname = y
.
.

Age = 5
height = 1
..

..
...
...
2014 Jul 24 08:15:16.675
...
..

Name = HHH
Lastname = BBSB
.
.

Age = 10
height = 2
..

2014 Jul 25 08:15:16.675
...
..

Name = SKSK
Lastname = SKSK
.
.

Age = 9
height = 3
..

..
...
...
2014 Jul 26 08:15:16.675
...
..

Name = x
Lastname = y
.
.

Age = 8
height = 1.5

=============================================================

Wanted output format :

Date/time| Name |Last name|Age|Height
2014 Jul 23 08:15:16.675|x|Y|5|1
.
.
.
.

[e.pol]

Are you have any idea ?, please show.
First, i will tried Line Input statement (http://msdn.microsoft.com/en-us/library/aa243392(v=vs.60).aspx) to test for can read larger file

[Needhelp2]

the file is too large to be open in excel.. :-(

[e.pol]

Are you want to open text file with VB ?