Andy Brownsword has a solution:
INSERT statement exceeds the maximum allowed number of 1000 row values
Folks may tell you there are better ways to solve the issue, but the likelihood is that you’re doing it this way for a particular reason. So let’s skip the spiel and jump straight to a simple solution.
Click through to see what you can do to get around that issue.