Adding new records in bulk

[Brian Campbell]

I had a dataloss from a main table but had some backup records. I want
to cut&paste say line:

__33__|__01/04/99__|__165_|______KA__|__________WI___|__1251654__ ___

so that my table gets the record with out having to go field by field
and looks like this:

Zone | Request | ID | LocalName | ManagingOffice | LoanNum
__39__|__08/04/98__|__542_|______NC__|__________WI___|__1255454__ ___
__33__|__01/04/99__|__165_|______KA__|__________WI___|__1251654__ ___

But I keep getting this error message: "The field is too small to
accept the amount of dat you attempted to add. Try inserting or pasting
less data."

Any clues? I'm choosing the entire record highlighted for the copy. Is
there a way to write an SQL to dump the needed records from one table
to another? Both tables are formatted indentically.

Thanks!!!!!!

[Arno R]

Just *select* the empty record before you paste.
You can copy all your records at once that way.

Maybe delete the records you don't need from your backup, select all thats left, and paste it.
Work with a backup of your backup if you choose the last option...

Arno R

"Brian Campbell" <ca***************@yahoo.com> schreef in bericht news:11**********************@f14g2000cwb.googlegr oups.com...

I had a dataloss from a main table but had some backup records. I want
to cut&paste say line:

__33__|__01/04/99__|__165_|______KA__|__________WI___|__1251654__ ___

so that my table gets the record with out having to go field by field
and looks like this:

Zone | Request | ID | LocalName | ManagingOffice | LoanNum
__39__|__08/04/98__|__542_|______NC__|__________WI___|__1255454__ ___
__33__|__01/04/99__|__165_|______KA__|__________WI___|__1251654__ ___

But I keep getting this error message: "The field is too small to
accept the amount of dat you attempted to add. Try inserting or pasting
less data."

Any clues? I'm choosing the entire record highlighted for the copy. Is
there a way to write an SQL to dump the needed records from one table
to another? Both tables are formatted indentically.

Thanks!!!!!!