importing excel file into contact

[Joe]

I am trying to import an excel file into my contact
folder. I get an MAPI error message OX80070057. It will
import only 7 contacts.

This is not only happening with by new computer but to
the laptop I use at the office.

I even saved the EXCEL file as a text file and tried to
import it and get the same error message.

Joe

 

[Karl Timmermans]

Since you indicate that you are getting identical results importing this as
either an Excel or text file - it sounds very much like have some invalid
data in either your 7th or 8th record which more likely then not are
"unprintable" characters. As such these characters won't be readily
"visible" without looking at your data on a "byte" level and look at the
"hex codes" of all characters in your file.

For a quickstart - look at record 6 and 7 to see which fields contain data
in #7 that are not in #6 (or records #7 & #8 depending on where the problem
is coming from). Only other solution is to delete the record and see if the
rest of the data gets imported correctly. This is not a completely uncommon
issue depending on "how" your data got generated in the first place. The
Outlook Import engine is not the most "resilient" once you have things "out
of the norm".

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

 

[Joe]

Thanks - that was it!

-----Original Message-----
Since you indicate that you are getting identical results importing this as
either an Excel or text file - it sounds very much like have some invalid
data in either your 7th or 8th record which more likely then not are
"unprintable" characters. As such these characters won't be readily
"visible" without looking at your data on a "byte" level and look at the
"hex codes" of all characters in your file.

For a quickstart - look at record 6 and 7 to see which fields contain data
in #7 that are not in #6 (or records #7 & #8 depending on where the problem
is coming from). Only other solution is to delete the record and see if the
rest of the data gets imported correctly. This is not a completely uncommon
issue depending on "how" your data got generated in the first place. The
Outlook Import engine is not the most "resilient" once you have things "out
of the norm".

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





.