Ray's Asp.net Blog
Answers and code snippets from ASP.NET projects (Webforms/MVC/Classic ASP)
Pages
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'
)
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)