db connection through coding

[Zeshan]

hi

1)how can i use a variable in the rs() to go through the fields, e.g

dim a as integer
for a =1 to 3
text1.text=rs(a)
next a

2)also how can i take the name of a table as input n create it
using the sql query

3)i ve "ID" as pri key, but when i run the following, n giving an input for the field "ID" but leaving the field "Name" as blank, an error=(table1.name cannot be a zro length string ) occurs.how do i resolve this err

rs2.Open "insert into zee(ID,Name,Phone) values(' " & MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, MSFlexGrid1.Col) & " ' , '" & MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, MSFlexGrid1.Col + 1) & "')", cn, adOpenStatic, adLockOptimistic


thankyou