[AccessD] Stored Procedure return value

I have a stored procedure that builds up a SQL statement 
that performs a bulk insert, then executes that sql statement.

I need to return the number of rows affected.  I assume I 
have to do something inside of the stored procedure but I 
have no idea what.

Does anyone know how to return the rows affected from a SP?

-- 
John W. Colby
www.ColbyConsulting.com