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 "Lee, Joomi" <joomi.lee@xxxxxxxx To: mso@xxxxxxxxxxxxx a.wa.us> Sent by: cc: mso-bounce@freelist s.org Subject: [mso] Re: Access: Paste Errors table 02/18/2005 04:32 PM Please respond to ..... mso Cathy, Thank you for that input. She is working with SAP data, which grows every week. Joomi Lee -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Cathy.Evans@xxxxxxxxx A paste errors table will show the records that did not paste due to errors. For example, the type may not match, like pushing text data to number or date field. When I get a paste errors table I check the records to see what the data looks like so I can spot what I need to correct either in the data or the table it is going into. I have not experienced the table growing, when I delete it, it's gone till I get a new one, and that's specific only to the table I pasted. Is she working with the same data each week, maybe with new records added or old ones revised? If so, there may be a problem with the table that's receiving the data and the remembering part is because it's the same records but with the new ones added. It's important to find out which records or fields are giving the problem and fix the input table or the query that is doing the production work. Without knowing more about the actual steps she's taking and what kind of data, etc., that's an overview, hth, Cathy ----------------------------------------------------------------------------------------------------- The information transmitted is intended only for the person or entity to which it is addressed and may contain proprietary, business-confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of the company. ------------------------------------------------------------------------------------------------------- ************************************************************* 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). //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 *************************************************************