Insertion Prob In Access database

[RBagade]

Dear all,

I m developping a project using VB 6.0 and Access-2007 as my databse.
I am collecting data in FlexGrid Control and using while loop I am inserting it in database. I am using ADO technique to insert record. I m using Following Code

rs = connection object;
i = 1;
while i < msflexgrid1.row s-1
msf1.col = 0;
temp1 = msf1.text;
msf1.col = 1
temp2 = msf1.text
rs.open("insert into inword values ' " & temp1 & " '," & temp2 );
wend

Sometimes it inserts data in database properly and sometimes it doesn't, When it doesnt insert data in database it goes into while loop but doesnt insert data.

Can any one please help me in this case

[debasisdas]

i dont understand why are you using a INSERT INTO sql statment to open a recordset.

[RBagade]

i dont understand why are you using a INSERT INTO sql statment to open a recordset.

Hi thx for ur reply. Welll I am not using insert statement to open, That code I am using it to insert Flexgrid rows into database. I m parsing flexgrid row by row and inserting it in database using ado technq.

rs.open("SQL statmt") this statement will be used to execute any sql statement in ADO.