I wonder...

miffe

New Member
Joined
May 3, 2006
Messages
15
We all know that it's dead easy to execute Query's and bring data from access into excel, as well as outputing cells from excel into access (.mdb)'s...

BUT...

Is it possible to execute a query from excel to retrieve the number of records in an access database in a remote computer? If so... how?

Thx -
Miffe
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Miffe,

The steps would be...

1. Create a recordset based on the table
2. MoveLast in the recordset
3. Return the RecordCount

You can only get the number of records by going to the end of the recordset, as far as I know

Denis
 

Watch MrExcel Video

Forum statistics

Threads
1,114,093
Messages
5,545,917
Members
410,711
Latest member
Josh324
Top