hey guys, I have a text file that is comma separated and at the same the, the values are enclosed in double quotes. "1234567890","01/30/2006","Deleted" In MySQL's load data infile(similar to MSSQL's bulk insert), I can specify a comma delimeter and at the same time, the double quotes too. However, I looked at MSSQL BOL and trying to find a similar functionality wherein I can specify double quotes too, but didn't see anything. I know I can BULK INSERT it and run UPDATE statement to delete all the double quotes. It will work but it's an burden to the CPU. Please let me know how I can do this by just using bulk insert. Data is not fixed width too. Thanks!