Everytime I seem to ask...
I seem to get little responce...
I cant get any of the responces to work
that I do have.. so im gonna ask again..

I need a row of a DB put in a array..
Can someone make me a lil test project that
puts a Row of a DB in a Array and sent it
to [email protected] ??!
The code ive been using does not work at all!


This is the code I was given....

--------------------------------------------------------------------------------
Private Sub Command1_Click()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim arrRec As Variant

cn.Provider = "Microsoft.Jet.OLEDB.4.0"
cn.Open "E:\ClientAlert\clients.mdb"

rs.Open "Select [Closing Date] From Clients", cn, adOpenStatic

If Not rs.EOF Then
arrRec = rs.GetRows
End If

rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
End Sub
--------------------------------------------------------------------------------

Would someone please send me a little test program
that works .. that does this??