Rajesh Gami

Rajesh Gami

  • 81
  • 24.4k
  • 1.3m

MVC_ How to upload excel data in DB

Aug 21 2018 6:37 AM
How to upload excel file int to sql server database.
 
 My Excel sheet demo like:
 
 Customer List:
 Name City Package Network Address
 Rajesh Kadi Abc-1 RG Network
 Ahmedabad
 Vishal  
 Rajkot Xyz-2 RG Network
 Ahmedabad
 
 
My database tables:
 
=> Package_Master
 
   P_Id
   P_Name
 
=> Network_Master
 
   N_Id
   N_Name
 
=> City_Master
 
   C_Id
   C_Name
 
=>Customer_Master
 
   Cus_Id
   Cus_Name
   P_Id
   N_Id
   C_Id
 
====================
then how to upload data in to all display table.
Please quick fast reply me 
 
 
 
 

Answers (1)