Importing to Outlook Contacts

[Bill McIntire]

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.

 

[Karl Timmermans]

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

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

 

[McintireB]

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.

 

[Karl Timmermans]

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