Hey there....
I am using a recordset to pull some data out of a table and in turn dump that data into a new table.
My code is as follows and works fine, but I am looking for assistance in dumping this into the new table.
Any help would be greatly appreciated.
--Art
Private Sub Form_Load()
Dim rs0 As Recordset
Dim ArraySplit() As String
Dim n As Integer
Set rs0 = CurrentDb.OpenR ecordset("UserF ile")
rs0.OpenRecords et
Do Until rs0.EOF
ArraySplit = Split(rs0![GroupList], "~")
For n = 0 To UBound(ArraySpl it)
Debug.Print rs0![User] & ";" & rs0![Name] & ";" & _
rs0![Mgr] & ";" & ArraySplit(n)
Next n
rs0.MoveNext
Loop
rs0.Close
End Sub
I am using a recordset to pull some data out of a table and in turn dump that data into a new table.
My code is as follows and works fine, but I am looking for assistance in dumping this into the new table.
Any help would be greatly appreciated.
--Art
Private Sub Form_Load()
Dim rs0 As Recordset
Dim ArraySplit() As String
Dim n As Integer
Set rs0 = CurrentDb.OpenR ecordset("UserF ile")
rs0.OpenRecords et
Do Until rs0.EOF
ArraySplit = Split(rs0![GroupList], "~")
For n = 0 To UBound(ArraySpl it)
Debug.Print rs0![User] & ";" & rs0![Name] & ";" & _
rs0![Mgr] & ";" & ArraySplit(n)
Next n
rs0.MoveNext
Loop
rs0.Close
End Sub
Comment