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....

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...

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...