Thanks for ur reply...

I tried like this.....

INSERT INTO Mytable

SELECT *

FROM OPENROWSET ('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};

DefaultDir=C:\ME\;Extensions=csv;', 'SELECT * FROM...

I'm using Bulk Insert command for inserting data from csv (comma dilimited) file which was converted from excel file using MS Excel 2003. But I think excel does not follow...