Importing Text File and Updating Excel Worksheet

I will try to be more clear of what is needed.

I have a text file as database. It is a fixed width, content database.

I need to import the file, segregate the fixed width datas into columns. And each line in the text file is a record and macro has to loop till the end of line in the text file.

Anyone just please give heads up.

Thank you.