Importing contact from Excel

[tammyb]

I am trying to import contacts from a spreadsheet in excel and it doesn't
recognize the header record. What do I need to do?

 

[Brian Tillman [MVP - Outlook]]

I am trying to import contacts from a spreadsheet in excel and it doesn't
recognize the header record. What do I need to do?

Describe your Outlook version, the file type of the file you're trying to
import, and exactly how you're trying to import it.

 

[Karl Timmermans]

"Doesn't recognize the header record" means what exactly? Was there an error
message of any kind? You do have a header record correct (first row
containing column names for all subsequent rows)?

Far too many possibilities so in the interest of speed and avoiding endless
questions:

Save your worksheet as a CSV file and try to import that file
a) if it works - your "named range" likely is incorrectly set
b) if it doesn't - contents of your first row likely is not a "header
row" and the data in the fields is causing the issue - go back and add a new
row at the beginning of the file with field names for each column being
imported - i.e. "FirstName","LastName","Some Field","Some Other Field" etc

Any follow up question regarding this should also include Outlook versions
and more specifically this is Outlook or Outlook with BCM (2 different
import/export engines).

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

 

[Diane Poremsky [MVP]]

See http://www.slipstick.com/Tutorials/import/import.htm - I'm guessing you
don't have the named range done correctly.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

Exchange Messaging Outlook newsletter:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.