Generate query from excel sheet

How to write query from excel sheet.

it is a very simple method to write query from excel sheet.
for example.

="insert into tablename(code,startdate,enddate,miniamt,amount,type,active) values('"&A1&"','2010-5-24','2011-5-23',300,30,'$',1)"

green text show you this is excel sheet column name.