Error 3047: Record is too large

[Imdabaum]

Append query does not work.

I copied the SQL Server table and pasted Definition only so all fields should be exactly the same.

I then did an unmatched query to find the missing records from the local table that were in the production data (this was all of the production records).

Then I did an append query to append all the data in missingquery to the local table. It does not work I get this same error message stating that the record is too large. This apparently happens if the record contains more than 2K of data. Help suggests that I split the data into tables.. A great idea if I had control over the server and anything else related to the data here.