Creating insert query using excel

posted in: MySql | 0


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,
country_name varchar(50),
country_status char(1)

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

Next Post

Leave a Reply