I got a situation.
I have some data in an excel sheet in a particular format (refer the attachment) and i want to insert the same record into a database, and the format of insertion is mentioned below
Eg: I got say 20 records in an excel and the pattern is like (A1,A2,A3,A4 and so on),
I want to insert the first 4 four records in a SQL query like (insert into xyz values (A1,A2,A3,A4)
next insertion would be (insert into xyz values A5,A6,A7,A8) and so on
i.e. i want to execute the query with 4 records each time, till it ends
Refer the screen shot for referece