Ray's Asp.net Blog
Answers and code snippets from ASP.NET projects (Webforms/MVC/Classic ASP)
Pages
(Move to ...)
Event registration app with QR/Paypal
Home
▼
Thursday, July 17, 2014
How to use Bulk insert to insert one column in a mutitple columns table?
One of solutions is:
Create a view from that table with only column you want to update.
The use bulk insert:
bulk
insert
TableView
from
'July17_2014.csv'
with
(
fieldterminator
=
','
,
rowterminator
=
'\n'
)
‹
›
Home
View web version