Excel 2000 e-mail addresses into Outlook 2000 contacts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LCAW - 25 Nov 2004 19:13 GMT

Urgent! Need to send these e-mails now due to deadline

Problem with transferring contacts with e-mail addresses from Excel 2000
spreadsheet to Outlook 2000 contacts. Import Export wizard in Outlook says:
"ODBC error occurred in Excel translator while opening file to build a file
map. Too many fields defined." However I cannot find how to map the file for
acceptance. Even if I delete everything except one column with a header, I
still get the same thing come up. Any ideas please?

Reply to this Message

Milly Staples [MVP - Outlook] - 28 Nov 2004 23:31 GMT

Create a couple of contacts in Outlook with all of the relevant information
filled in. Export this to a .csv file. Compare the one you just created to
your exisiting one and massage yours accordingly. Outlook does not use
custom fields in importing so if you have any, you will need to remove them.

Signature

--?
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After furious head scratching, LCAW asked:

| Urgent! Need to send these e-mails now due to deadline
|
[quoted text clipped - 5 lines]
| except one column with a header, I still get the same thing come up.
| Any ideas please?

Reply to this Message