Insert query using excel

(Last Updated On: August 11, 2016)

Step 1:Create the fields and values in the excel as like below,

Rno Name Department Percentage
100 AGN CSE 76
101 PHK CHEM 81
102 RVS ECE 85
103 RGN MBA 84
104 GVS PHD 92
105 PK MECH 80

Step 2:Type like below to create the query for all the set of values in the excel,

insert into student_details(RNO,NAME,DEPART,PERCENT) values(100,’AGN’,’CSE’,76);

Reference image:

INSERT QUERY IN EXCEL

 

 

 

Thanks for reading this post……..!!!

231 total views, 0 views today

Leave a Reply

Your email address will not be published. Required fields are marked *