Try this - create a couple of contacts in Outlook and export to Excel.
Examine the output and your Excel spreadsheet and massage yours accordingly.
I bet you don't have your field names correct.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.

After furious head scratching, Richard asked:

| I have tried a couple of times now to import contacts (28 of them)
| from a spreadsheet into Office Outlook 2003 SP3 (running under Vista
| Home Premium).
|
| The Import dialogue progresses perfectly well, and enables me to
| select spreadsheet (though not the page within it!) and the contacts
| folder to use. It then lets me map the fields as I wish, and goes
| through a progress window where it claims to be importing the entries.
|
| Afterwards I find that none of the entries in the spreadsheet has been
| imported. None at all. They aren't in any other contacts list
| either.
|
| Is this a known problem?
|
| Is there a solution?
|
| TIA
| Richard