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