-
April 9th, 2007, 06:02 AM
#1
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
-
April 9th, 2007, 07:51 AM
#2
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.
TheCPUWizard is a registered trademark, all rights reserved. (If this post was helpful, please RATE it!)
2008, 2009,2010
In theory, there is no difference between theory and practice; in practice there is.
* Join the fight, refuse to respond to posts that contain code outside of [code] ... [/code] tags. See here for instructions
* How NOT to post a question here
* Of course you read this carefully before you posted
* Need homework help? Read this first
-
April 16th, 2007, 09:06 AM
#3
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
-
April 16th, 2007, 09:07 AM
#4
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|