Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET SQL-Server
I want to bulk insert a file like
 
1,"1,500",200
 
"1,500" I want to insert into a single column but it inserts "1 in one column and 500" into another column
 
is there any way for bulk insert such type of file
 
my code is like this
 
BULK INSERT #temp FROM 'C:\Uploads\testfile.csv' WITH ( FIELDTERMINATOR = ',' ,ROWTERMINATOR = '\n',CHECK_CONSTRAINTS)
Posted 27-Mar-13 21:41pm
Edited 2-Apr-13 1:15am
Maciej Los159.5K
v6
Comments
Menon Santosh at 28-Mar-13 2:52am
   
Post your code
Madhav Hatwalne at 28-Mar-13 6:23am
   
code added

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Check This Code.
Dim sValueAs String=1,"1,500",200
Dim words As String() = sValue.Split(New Char() {"""c})
 
U get Value 1, after 1,500 and Last ,200
  Permalink  
Comments
Madhav Hatwalne at 28-Mar-13 6:17am
   
but these values are in file and i m using bulk insert option of SQL server
that means i have to read file and generate again another file?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 575
1 Kornfeld Eliyahu Peter 409
2 Maciej Los 369
3 DamithSL 196
4 OriginalGriff 188
0 OriginalGriff 6,353
1 DamithSL 4,854
2 Maciej Los 4,476
3 Kornfeld Eliyahu Peter 4,058
4 Sergey Alexandrovich Kryukov 3,917


Advertise | Privacy | Mobile
Web04 | 2.8.141223.1 | Last Updated 2 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100