Geting Date from record

Hi,

I Really need to get the code to do this..

1. Open C:\ClientAlert\Clients.mdb
2. Find out how many rows there are in a DB Field
3. ReDim Array to the records in the field
4. Copy ALL Records from one field to a array

can someone help me out????

Thankyou...

Try GetRows, look it up in the help, it retreives records from a recordset into an array.