In Most of our project we got data from client in an excel file and we have to insert the same in our database. If excel data is complex then it is feasible to write the program to read the excel file and write the data back to the desired database.
If it is a simple excel file and it requires only simple queries to be pass then we can use excel to format the insert query and run the same in the sql yog window without involving a single line of code.
For example I am using the country table structure as defined below
Create table country
country_id primary key auto increment,
Below is the query which I am going to use for data insert into country table
Insert into country(country_name,country_status) values (‘India’,’A’);
Watch the video below