hay my friend one thing is Clear that u hv Fixed number of Colums and non fixed number of rows. so the best and easy way what i suggest is that with msflexgrid
for aloop=2 to msgflexgrid.rows -1
.row=aloop
.col=1
rs("datafild")=.text
'----eighter u can write single line
rs("datafiled")= .TextMatrix(aloop,1)
next
end with
if it's work plz let me know .........i m waiting for ur reply