BulkInsert Problem
-
Hi, I have a problem with a bulkinsert of csv file.The file is in the format that some columns are in the format of string and the same is terminated by a "","" charecter and some column are in the form of int and that is terminated by a "," charecter.While Bulkinserting if the column is having the comma(,) with in it, then the data is uptating for the next column. Can anyone help me on this. Regards Sabarinathan T.
-
Hi, I have a problem with a bulkinsert of csv file.The file is in the format that some columns are in the format of string and the same is terminated by a "","" charecter and some column are in the form of int and that is terminated by a "," charecter.While Bulkinserting if the column is having the comma(,) with in it, then the data is uptating for the next column. Can anyone help me on this. Regards Sabarinathan T.
Hello, That will always happen unless the delimiter is changed to something else eg "|". Otherwise: 1,abc,d,2 cant be 3 columns in a CSV file, because CSV=COMMA SEPERATED VALUE, so what you want is: 1|abc,d|2 which will always be 3 columns. Regards, Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
-
Hello, That will always happen unless the delimiter is changed to something else eg "|". Otherwise: 1,abc,d,2 cant be 3 columns in a CSV file, because CSV=COMMA SEPERATED VALUE, so what you want is: 1|abc,d|2 which will always be 3 columns. Regards, Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
Hello Adeel, Thanks a lot for the suggestion.It could help me to change to other delimiter like '|'. Rgds Sabari