adjusting a macro that retreives access data

[Guest]

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.

 

[NickHK]

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