[mso] Re: Access: Paste Errors table
- From: Cathy.Evans@xxxxxxxxx
- To: mso@xxxxxxxxxxxxx
- Date: Fri, 18 Feb 2005 21:17:14 -0500
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
*************************************************************
Other related posts:
