Bulk Insert
Database
1
Posts
1
Posters
0
Views
1
Watching
-
While i use the bulk insert to import the csv file into my SQL server database, i am facing problem as the csv file have column with money data such as 1,111,111.00. As i set the FIELDTERMINATOR =',', it will separate out the value 1,111,111.00 to few of columns as the value have comma in it. Any suggestion to solve this problem? Thank You.