how to make bulk updates?

[vgvkarthik]

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

[TheCPUWizard]

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.

[cjard]

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

[cjard]

step 1 might not be necessary; a generic dataset should be able to read Excel's xml if it is just a single column