how to make bulk updates?
hi i am having more than 50k records in my table.
I am having 100 values in an Excel sheet.
I wants to update a column in my database table,
with the values in excel.
Eg:
StudName --> column in SQL Table
Name--> Column in excel sheet.
How to do this?
Thanks,
Karthik
Re: how to make bulk updates?
I would...
1) Create a temp table in the SQL DB with the contents of the Excel sheet
2) Execute a stored proc to perform the necessary updates.
Re: how to make bulk updates?
I would:
1) Create an XML transform to turn excel XML into dataset XML
1.1) read the resulting xml straight into a dataset
2) Use a correctly configured tableadapter to send the rows to the database
Re: how to make bulk updates?
step 1 might not be necessary; a generic dataset should be able to read Excel's xml if it is just a single column