Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to save rows in grid to database
- Thread starter darkradar
- Start date
Try this out and let me know if it works,
With Grid
I = 0
If .Rows >= 1 Then
For I = 1 To (.Rows - 1)
If .TextMatrix(I, 1) <> "" Then
conInv.Execute "INSERT INTO Table_Name(pc_index,comment) " _
& "VALUES(" & pc_index & ",'" & .TextMatrix(I, 1) & "');"
End If
Next I
End If
End With
With Grid
I = 0
If .Rows >= 1 Then
For I = 1 To (.Rows - 1)
If .TextMatrix(I, 1) <> "" Then
conInv.Execute "INSERT INTO Table_Name(pc_index,comment) " _
& "VALUES(" & pc_index & ",'" & .TextMatrix(I, 1) & "');"
End If
Next I
End If
End With
- Status
Similar threads
- Question