[mso] Re: Access: Paste Errors table

Thank you so much for this helpful advice.  Last week we figured out where
the problem was coming from:  the SAP transaction she was entering was
pulling up all records as well as records to which changes had been made,
with both final and original record having the same sort number.  Since
Access was only accepting unique primary keys and the sort number had been
designated the primary key field, it was generating paste error messages and
only accepting the first record as "good" and the second record with same
sort number as the "paste error."  My apologies for responding so late, I
was out on training yesterday. 

Regards,
Joomi Lee

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Cathy.Evans@xxxxxxxxx

I agree with Lisa about checking to see if the right number of records
inserted.  How is your customer connected to the SAP data, and what is she
doing with the data once she's pulled it?  I work with alot of oracle data
that's outside my area of being able to control the tables, so I download it
and further work with it where I can manipulate and control the formats.
Some of the download is just appending new data and sometimes it is hard to
match the formats coming and going.  Paste errors catch the records that
can't be pasted into the table source, so it would be a concern to check out
to make sure no records are missing.  If you haven't already checked out
below url in your 'googling', it's pretty thorough.  Ultimately, it can be a
trial and error search with the volume of records it sounds like she's
working with.  Can she test on a filtered query to only catch say a 30 day
look ahead or behind date group to get a better chance to look at the paste
error records and see what's happening.  Does she have control over the
destination table to alter the format that won't accept the SAP side?  If
she's pulling SAP data which is already formatted and out of her control,
she may be able to loosen some of the formats on the destination side to
accommodate whatever is the problem.

http://office.microsoft.com/en-us/assistance/HP051875751033.aspx
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: