Pb importing from Excel to contact (loss of information)

[bbnimda]

Hi all,

I try to import data from Excel to my contact, but it doesn't work as
espected ....

Some cell aren't imported there's no reason ....

my original file (Excel) was about 1200 line so I reduce it to 200 Line

but the Pb is still here

ex:

in the line there is

Name firstName tel fax mobile user1 user2 user3 user4
profession etc....

for some lines all cell are imported and for other some cell are loosed in
importation

I repeat in one file 10 time the same line (copy / paste) and the result is
the same, some cell in these line are missed

Tks for Help

 

[Eric Legault [MVP - Outlook]]

Do any of the cells contain text with multiple lines? Carriage returns and
line breaks are frequent contributors to import errors when working with
Excel.

 

[bbnimda]

Hi Eric

Yes I importe cell to Note and these Cell are multiple line, but....

these cells are correctly imported to Note (contact Note) ....

Any idea ?

tks

 

[Eric Legault [MVP - Outlook]]

The Note field, which goes in the message body, can properly handle and
display multiple lines of text. For other fields, I suspect it may truncate
the data or not process it at all.

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/

 

[bbnimda]

Is there a solution ?

some field contain only phone number and they aren't imported ....

The Note field, which goes in the message body, can properly handle and
display multiple lines of text. For other fields, I suspect it may
truncate
the data or not process it at all.

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/

Hi Eric

Yes I importe cell to Note and these Cell are multiple line, but....

these cells are correctly imported to Note (contact Note) ....

Any idea ?

tks


"Eric Legault [MVP - Outlook]" <[email protected]> a écrit
dans
le message de news: (e-mail address removed)...

Do any of the cells contain text with multiple lines? Carriage returns
and
line breaks are frequent contributors to import errors when working
with
Excel.

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


:

Hi all,

I try to import data from Excel to my contact, but it doesn't work as
espected ....

Some cell aren't imported there's no reason ....

my original file (Excel) was about 1200 line so I reduce it to 200
Line

but the Pb is still here

ex:

in the line there is

Name firstName tel fax mobile user1 user2 user3
user4
profession etc....

for some lines all cell are imported and for other some cell are
loosed
in
importation

I repeat in one file 10 time the same line (copy / paste) and the
result
is
the same, some cell in these line are missed

Tks for Help

 

[Eric Legault [MVP - Outlook]]

It's really difficult to determine which data is causing the problem without
the actual data in my hands. Could you e-mail it to me so that I can have a
look?

An alternative would be to import the data using VBA, and then you will have
full control.

Custom import and export from Microsoft Outlook:
http://www.outlookcode.com/article.aspx?ID=23

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/

Is there a solution ?

some field contain only phone number and they aren't imported ....

The Note field, which goes in the message body, can properly handle and
display multiple lines of text. For other fields, I suspect it may
truncate
the data or not process it at all.

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/

Hi Eric

Yes I importe cell to Note and these Cell are multiple line, but....

these cells are correctly imported to Note (contact Note) ....

Any idea ?

tks


"Eric Legault [MVP - Outlook]" <[email protected]> a écrit
dans
le message de news: (e-mail address removed)...
Do any of the cells contain text with multiple lines? Carriage returns
and
line breaks are frequent contributors to import errors when working
with
Excel.

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


:

Hi all,

I try to import data from Excel to my contact, but it doesn't work as
espected ....

Some cell aren't imported there's no reason ....

my original file (Excel) was about 1200 line so I reduce it to 200
Line

but the Pb is still here

ex:

in the line there is

Name firstName tel fax mobile user1 user2 user3
user4
profession etc....

for some lines all cell are imported and for other some cell are
loosed
in
importation

I repeat in one file 10 time the same line (copy / paste) and the
result
is
the same, some cell in these line are missed

Tks for Help