G'day Mahadevan

Take a look at the following link

http://www.rondebruin.nl/txtcsv.htm

The code will do pretty much what you need.

Where the code states this

..TextFileStartRow = 1

change it to

..TextFileStartRow = 5

Assuming the TXT file has no header row, if so, then your row start would be
6.

HTH
Mark.