Hi handkot,

Its finally working,

Thanks a ton.. 🙂

Thanks again,

DCS

@Handkot,

I changed my format file to match exactly with urs.. changed the table as well to use date in nchar format. So as good as using ur version. I will...

Hi Handkot,

Thanks for your response. I tried the bulk insert with your coding, but I got the following error:-

Msg 4864, Level 16, State 1, Line 2

Bulk load data conversion...

Hi Handkot,

The samole of data in csv file is as follows:-

MK,12345678,ABC 123lr RK Finish abcde abcdef ,ABCDEFGH,A123456,1,1234,18/09/2010,W1,

CD,98765432,RR CTR APPLE JAM AND...

@handkot, I have used it and it works the problem is when I get two rows which have commas in the fields. it doesnt work for them. and strange thing...

Yes they are.. I even tried using comma as field seperator and \t as field separator. When i use either in the stored procedure the error remains the same :-

Msg...

handkot (9/16/2011)

---

8.0

10

1 SQLNCHAR 0 3 "," 1 CompanyID ""

2 SQLNCHAR 0 9 "," 2 ItemCode ""

3 SQLNCHAR 0 38 "," 3 Descritpion ""

4 SQLNCHAR 0 9 ","...

steve smith-401573 (9/15/2011)

---

@dcs.. - why did you choose the parameter setting '101'? Look up the command (Books OnLine [BOL], or brute force via Google) and make certain you understand...

The query :- SELECT CONVERT(datetime, dt,101) FROM [TestDB].[dbo].[test_date]

gave me the error:-

Msg 242, Level 16, State 3, Line 1

The conversion of a varchar data type to a datetime data type resulted...