Hi Skabialka,
Pasting records into a table sounds so easy. Just like fourth grade.
Unfortunately, Access is a little pickier than your fourth grade teacher
was. If Access can’t paste any or all of the data you want to move or copy,
you will see a message describing the problem with a clue about how to fix
it, just like the messages on the homework you got back from your teacher.
After explaining the problem, Access displays another message, indicating
that it has saved all the records that it couldn’t paste in the Paste
Errors table. Reviewing the Paste Errors table is a convenient way to
troubleshoot the problem you have.
Access might not be able to paste data for several reasons, including the
following:
You tried to paste text with more characters than the field you’re pasting
it in allows.
The value you are trying to paste isn’t compatible with the type of data
the destination field can accept.
The source field contains a value that doesn’t fit with certain property
settings in the destination field, such as a validation rule, an input
mask, or a setting in the Required or AllowZeroLength property.
You tried to paste records from more fields than the destination table
contains.
The following solution shows how to deal with these sticky pasting problems.
How to fix it:
In the message box that explains the problem, click OK.
Click to view graphic
Click OK in the message about the Paste Errors table, and then open the
Paste Errors table in datasheet view. You might need to correct the errors
that caused the paste failure one by one.
Open both the source and the destination table in design view.
On the General tabs of the Field Properties areas of the source and
destination tables, compare the Field Size property settings of the problem
fields. One of the fields might be too small to contain the data you are
pasting. For example, text from a field that allows 255 characters won’t
necessarily fit into a field that allows only 40. Adjust the Field Size
property setting in the appropriate table.
Click to view graphic
Make sure the data types are compatible. For example, you can’t paste text
into a field with a Number data type.
Check the property settings of the destination fields for validation rules,
input masks, and other restrictions. The data you are pasting might not
follow the rules set up for the field you are pasting the data into.
If the problem is that you are pasting records from more fields than the
destination table can handle, select fewer fields to paste.
After you’ve modified settings and field types, save any changes you’ve
made to the tables’ design.
Select the records in the Paste Errors table and click the Copy button on
the toolbar.
Click to view graphic
In the destination table, select the blank new record row and click Paste.
Delete the Paste Errors table from the database.
For Additional Information :
http://www.microsoft.com/mspress/books/sampchap/4756.asp
Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.
