update tables based on multiple joins

Question

I have automated Excel within VB.NET and populated spreadsheet using SQL 2008 R2.  The SELECT statement consists of multiple JOINS (4-6). I need to let the user massage the data within the spreadsheet, then update the source tables based on their changes.  Currently, I am putting the SELECT into a single worksheet, but running into trouble when I try to do updates to tables that have multiple records, for example, a single customer may have 6 phone numbers where the phone numbers are in a single table - I need to know which record to update.  Any SQL suggestions to handle these updates would be appreciated.  TIA.

Answer 1

Hello,

Please, could you give us more informations about the structure of your table(s) in your SQL Server database and your Excel sheet and the rules you are using to load your spredsheet ?

According to your reply, maybe a moderator will move your thread towards another forum more convenient to your problem ( avoid to recreate another thread in another forum, it would let an unsanswered thread and it would be necessary for a moederator to do a merge, an complicated and useless operation ).It is one the most current task for the moderators.

We are waiting for your feedback to try to help you more efficiently.

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.