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.
0 comments:
Post a Comment