1
Answer

MVC_ How to upload excel data in DB

Rajesh Gami

Rajesh Gami

6y
942
1
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)