Thank you GSquared,

Sorry i could not explain the requirement properly as i has to hurrry..

Anyways, the text file is a comma-delimited file(csv) with 6 entries(columns) in each row,

With 'bulk insert'...