Access DAO to SQL Stored Proc

Legacy Access 2000 app upgrading to ISP-hosted SQL Server 2000. I just need one stored procedure + corresponding Access VBA to insert the entire contents of an Access table (which will hold 100 - 500 records) into an? SQL table, but I have to have it done using OPENXML, and the XML must be generated from a DAO RecordSet. The further requirement being that all the code must be in Access VBA/SQL Server Stored Procedure and nothing in any external libraries. I can provide Access source table plus SQL login for the target.