Importing to Outlook Contacts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill McIntire - 20 Sep 2004 20:57 GMT

I am running XP Pro with MS Professional. I am trying to
transfer an excel spreadsheet, that was emailed to me,
with contact information. It was a prev export from
Outlook 2002. When I try to import it back into my
Outlook I only get a record for each section used of the
first row. The rest of the 200 lines end up as 22k+ empty
records. I have tried to import excel, comma delimited,
tab delimited, access all have same results. There is no
posibility to get a PST of the original data.

Reply to this Message

Karl Timmermans - 20 Sep 2004 21:27 GMT

Could you elaborate on what you mean by "a record for each section used of
the first row"? If you're getting the same results from all formats then
there is something wrong either with the layout of your data or a problem
with the data itself. If this is the exact same file originally exported by
Outlook - the data structure should be in tact.

Structure should be that the <first row> contains the column (field) names
for each row that follows it. If you are using Excel - your "named range"
should encompass all rows including the header row.

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 am running XP Pro with MS Professional. I am trying to
> transfer an excel spreadsheet, that was emailed to me,
[quoted text clipped - 5 lines]
> tab delimited, access all have same results. There is no
> posibility to get a PST of the original data.

Reply to this Message

McintireB@aol.com - 22 Sep 2004 21:51 GMT

When I get the first record group transfered the name is
one record, the buss phone is another record, the mobil
phone is another record ETC all in the correct fields but
different records. But only the original contact is
split up. The rest of the import reveals 20k+ totally
empty records in all fields.

>-----Original Message-----
>Could you elaborate on what you mean by "a record for each section used of
[quoted text clipped - 20 lines]
>
>.

Reply to this Message

Karl Timmermans - 23 Sep 2004 15:48 GMT

Does your data conform to the following as outlined in my first response?
Not sure what you mean by "first record <group>".

"Structure should be that the <first row> contains the
column (field) names for each row that follows it.
If you are using Excel - your "named range"
should encompass all rows including the header row."

One contact = all columns for one contact = one row.
Header row + all contacts = one named range.

Karl

> When I get the first record group transfered the name is
> one record, the buss phone is another record, the mobil
[quoted text clipped - 38 lines]
> >
> >.

Reply to this Message