Can anyone help me adjust the "big macro" GetDataFromAccess from the
following link, so that it counts the number of records, not retreive them in
the test examples ?

http://www.rondebruin.nl/accessexcel.htm

Any help would be appreciated.
--
Regards,

timmulla

You can check the .RecordCount property of the returned recordset. For this
to give reliable results, you need a client-side cursor also. something like
this as far as I remember:

With MyDatabase
.CursorLocation = adUseClient
.Open MySQL, MyConnection, 0, 1, 1
MsgBox .RecordCount
End Sub

NickHK

"timmulla" <(E-Mail Removed)> wrote in message
news:EB591487-E3D3-4FA0-B2D2-(E-Mail Removed)...
> Can anyone help me adjust the "big macro" GetDataFromAccess from the
> following link, so that it counts the number of records, not retreive them
in
> the test examples ?
>
> http://www.rondebruin.nl/accessexcel.htm
>
> Any help would be appreciated.
> --
> Regards,
>
> timmulla