By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,376 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

Adding new records in bulk

P: n/a
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!!!!!!

Jan 11 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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!!!!!!

Jan 11 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.