How to insert data in database in qtp

How to insert data into database in qtp

Code below can be used to insert a record or data into database in qtp

Set cn= createobject("ADODB.Connection")

cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=G:\priyanka\vb6\admission_project.mdb;Persist Security Info=False"

Set rst = createobject("ADODB.Recordset")

cn.execute "insert into table(column1,column2) values (colvalue1,colvalue2)"