Created an INSERT INTO stored proc in an Access Project (MS SQL) which appends rows from one table to another.

Access by default only displays the first 10000 rows of a SQL table. I set the limit value to 0 in order to display all rows...

Then I run the stored procedure to append data to the destination table, but only the first 10000 rows are appended.

Is there a setting or SQL statement to append all rows? I have tried:

INSERT INTO tblDest (field1, field2)
SELECT TOP 100 PERCENT field1, field2
FROM tblSource