Paste Errors table

[LAS]

I have a backend database that contains a table called "Paste Errors."
There are 6 records in the table that have columns found in other tables,
but don't exactly match any other tables. I can't imagine that I created
this table myself. Does anyone know where it might have come from?

TIA
LAS

[John W. Vinson]

Post by LAS
I have a backend database that contains a table called "Paste Errors."
There are 6 records in the table that have columns found in other tables,
but don't exactly match any other tables. I can't imagine that I created
this table myself. Does anyone know where it might have come from?
TIA
LAS

Just what it says: from paste errors. At some point it seems you copied and
pasted some data into one or more tables, either from other tables, from Excel
or from an external text source; these records violated some constraint or had
incorrect datatypes.

If the six records don't contain data that you need, it's safe to just delete
the table. If they do, you can manually enter the data into the appropriate
table.