Importing from excel to Outlook

J

jhiggins

I am having trouble finishing the process of getting my email list from a
excel spread sheet into my contacts in outlook.I get an erro message that
says "An ODBC error in the Mircrosoft Excel 97-2003 translator while opening
a file to build a field map. Too many fields defined. Can anyone help me.
 
K

Karl Timmermans

Max # of columns in an Excel worksheet used for importing = 127 so.......

#1 - Your named range is not correctly defined and includes more than 127
columns OR
#2 - You are trying to use a worksheet with more than 127 columns

Options

#1 - Fix your worksheet and/or named range or reduce # of fields OR
#2 - Save your spreadsheet as a CSV file and import that file instead (max #
of fields allowed = 255)

*** given that you cannot import any data into any custom fields using the
Outlook import wizard, you would never require/need to exceed 127 columns to
populate a standard Outlook contact.

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
 

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

Similar Threads

Converting isse with Export in Outlook 0
Saying "too much data" when transfering from excel to outlook. 1
Exporting contacts to Excel 97-2003 5
Importing data from Excel to Outlook I get error too many fields 0
what is File Access Engine (.FAE) DLL or ValuPak? 1
Importing Excel Into Outlook Contacts - Translator Error 0
Export to XLS error: A file error has occurred... 2
Import contatcts from Excel - select file -> next grayed out 1

Top