I have an access front end linked to some tables in a Sql Server 2005 back end. I would like to create a stored procedure in Sql Server that appends all records from Table 1 into Table 2. I then need to be able to execute that Stored Procedure from my Access front end. My access front end is linked to Table 2. I have never done this before and need some help with the sp syntax and how to call it. Thanks.