Shamshad,

Turn on the Macro reporter and record the importing of the file using
comma delimeters.

Once you have this code, you can modify it (ALT-F11) to perform the
process again as a macro.

The construction of a Pivot Table from the resulting columns can also
be recorded and tweaked to later repitition.