import excel data into mysql table using stored procedure

Question

Hi All,

 

i have an Excel sheet with multiple columns need to import excel data into different tables using stored procedure

 

my excel column below for ur ref

 

Std Number	Std Name	Department	Activity
1001	kowsic	ECE	project,sports
1002	sankar	EEE	sports,research

 

 

 i have an table in mysql side called Studentdata

 

studentdata table columns like below

 

column	datatype
stdnum	int
stdaname	varchar(100)
Department	int
Activity	nvarchar(max)

 

Department column refers department table Id

 

 

need to write a stored procedure and inset into this table from excel sheet