MS Flex Grid

[CM670]

I have an msflex grid with 3 columns and it doesnt have a set number of rows.

Is there a way i can loop through all the rows and add the values to a database table. I have all my connections set up just need help adding them to the table.

Eg my grid is like this

Name        staff id      dep
Peter        12345        bg
Mary         24343        ma
jack          99898        op  
(the number of rows varies)

How can i add the names to the 'names' to the name field of my database, the staff ids to the object id field of my databse and the deps to the 'section' field of my database?


Would really appeciate any help with this. Have sat for hours trying to figure it out!

Thanks!