Use saved queries as opposed to SQL statements as the data sources for Access objects. The wizard will create a corresponding SQL Server object for each saved query.

The Count function helps you easily create a query that, based on any criteria, sums up the number of Access records you have. Here's how to use it.

Create a query from within Access that attaches to my SQL Server and retrieves the recordset. I'd likely use the same technique I applied in this thread. <BR>2.

It is possible to automate Access from Excel using VBA code, this woukld allow you to run any queries, also those containing user defiend functions. So you could run a query to empty the tabel and ...