Hi,

In my ecommerce site, I want to give merchants a way to insert/update data in bulk i.e. ProductID and Price. It makes sense to use Excel sheets for this purpose. If I were to read everthing line by line from the Excel sheet and call a stored procedure, each transaction would generate hundreds of database hits. What is the best way to handle this?

Another important feature is that if the vendor already has a ProductID in the database, the new data should overwrite the old. So it will be a MERGE statement in the backend. I'd appreciate some pointers in handling this.