|
Subject:
|
Append query (ADP) only appends first 10000 rows
|
|
Posted By:
|
U.N.C.L.E.
|
Post Date:
|
4/5/2006 3:45:22 PM
|
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
|
|
