Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Contacts / September 2005

Tip: Looking for answers? Try searching our database.

MAPI error 0X80070057

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Knowsome - 27 Sep 2005 13:29 GMT
I was attempting to import an Excel file of name, address etc into Outlook.  
I cross matched the Excel named ranges with that of Outlook and clicked
finish.  After a few seconds the above message came up and although some
information was imported it was only the first line of the address.  Any
clues as to how I screwed up?
Karl Timmermans - 28 Sep 2005 02:35 GMT
Not sure what you mean by "some info was imported". Some info on the very
first record (row)?

Anyhow without knowing specifics of the data file itself other then it's
Excel - suggestion would be to isolate the record that incurred the issue
(if it's the first - it makes it much easier). This could very likely be a
data related issue with one of the columns being "extremely long" for the
target field it's being imported into (in this case - I'd look at a text
field that is longer then 255 characters as a starting point).

Karl
Signature

__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com

>I was attempting to import an Excel file of name, address etc into Outlook.
> I cross matched the Excel named ranges with that of Outlook and clicked
> finish.  After a few seconds the above message came up and although some
> information was imported it was only the first line of the address.  Any
> clues as to how I screwed up?
Knowsome - 29 Sep 2005 09:44 GMT
Thanks for trying to help - even though the info I gave was inadequate.  The
Excel spreadsheet I am attempting to import from has data in columns and
rows.  The first row contains the headers of 'First name', 'Second name',
'Title' etc and the columns fill in the detail for each contact so that each
row beneath the title contains the full contact details seperated according
to the headers.  There are 30 contacts.  Each column has been highlighted and
given a name.
In Outlook I click 'file' 'import' and point to the spreadsheet.  I get the
list of fields on the spreadsheet with a blank tick box to the left of each
field.  I check the first and if it is not recognised by the program I am
prompted to identify which of the fields in Outlook it relates to.  I then
drag from the left and connect to the field on the right then click 'OK'.  
This procedure is repeated for all Excel source fields.
I click 'Finish' and the import.  The process starts and then I get the
error message shown in the subject.  It is headed 'Translation error'.  I
selected to carry on with other steps and then look at the resulting contacts
list.  The 'title', 'first name' and 'last name' were not imported at all.  
The were some 200 'contacts' set up.  All had only one field filled in and
none linked the full contact details in one 'contact' card.
Any assistance greatfully received.

> Not sure what you mean by "some info was imported". Some info on the very
> first record (row)?
[quoted text clipped - 12 lines]
> > information was imported it was only the first line of the address.  Any
> > clues as to how I screwed up?
Karl Timmermans - 29 Sep 2005 17:06 GMT
To keep this as simple as possible - suggest repeating these steps as you
outlined into a new folder. When you encounter the error (sounds like some
contacts were imported) - find the last contact in your input data source
that succeeded.

One of the causes of the error you have received is that the length of a
field (the contents of the field - not the field name) exceeds 255
characters) which is what I suggested that you look for. To ensure that this
has absolutely nothing to do with the worksheet itself, save your data as a
CSV file and import that. If the problem repeats itself - you definitely
have an issue with your data that you need to locate and remove.

Karl

__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com

> Thanks for trying to help - even though the info I gave was inadequate.
> The
[quoted text clipped - 44 lines]
>> > Any
>> > clues as to how I screwed up?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.