Can bulkload update existing data in a table?

Hi.
I'm new to transfering data from XML to an SQL Database. I'm using SQLXML Bulkload. I can insert data into the table successfully but I cannot figure out how toupdate existing data. Is this possible in Bulkload or should I use Updategrams instead? If it is, how can go about doing this?

I used Bulkload because I read up that it was good for large file transfers.

Anyone?

Hi

you cannot really use bulkload for updating directly.... you could either use updategrams, or if you still load lots of data, you could use bulkload into a staging area and then do the updates and final inserts relationally from the staging tables into your final tables.

Best regards

Michael

|||Thanks so much!
I've decided to handle the updates separately and not use updategrams because its too meticulous to deal with especially since I hav to do this for different tables and xml files.

So what I'm doing is having a transition (temporary) table that will update the table. The mapping problem was solved by using Dictionary<>.

Thanks!