Excel 2000 e-mail addresses into Outlook 2000 contacts

G

Guest

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?
 
M

Milly Staples [MVP - Outlook]

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.

--
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
|
| 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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top