Store csv file in sql tqble

Question

Hi All,
         I want to store a csv file in sql table can u help me please..
If I am using excel file except csv it is working fine..
But when I am using csv file it is throwing exception "External table was not in correct format". 
Please help me
Anish