Updating records usign XML bulk load

[IS300]

I am currently using XML bulk load to insert status reports into our SQL Server 2000 database. However, theses reports may come in throughout the day, if they have been updated. I would therefore need to have the SQL records updated as well. Is there a way that XML bulk load will do this? I do not want to have to delete and readd the record every time there is an update to the report.

Thanks.

 

[Programmer99]

I'm having the same issue. Have you found a way to solve this?

 

[IS300]

Nope, I haven't, so I cheated.

I make it so that it deletes the previous record, then inserts the new one.

We only have at most 19 records for each day, so I can get away with this.