Riddhi Valecha

Riddhi Valecha

  • 428
  • 3.2k
  • 396.9k

Update / Insert from excel to SQL Server

Apr 14 2016 8:25 AM
My Requirement is  -
1. User will select only excel sheet in File Upload Control - Done.

2. On button click event, the user will get the worksheets of excel file in a dropdownlist (Sheet1 , Sheet2, Sheet3, Sheet4, etc)

3. Table structure -
ID Code Description Datetime (ID - PK, auto increment ; Code - unique)

4. In excel , there will be 2 columns (Code , Description).

5. System Flow - User will check if Code exists in the SQL Server table or not. If exists, then update the description. If not, then insert the Code and Description

Please guide !!

Answers (3)