Importing Excel 07 file into Outlook

  • Thread starter Thread starter Tracey
  • Start date Start date
T

Tracey

I am trying to import excel file and got an ODBC error - too many fields
defined - what can I do?
 
The usual thing I try is to first export a calendar folder as an XLS file
then use that file as a guide to create my import file.
 
Reduce the number of fields to be less than 127 when using an XLS file
and/or make sure that the named range you are using is correct (i.e. does
not include more columns than necessary). Alternatively, if more than 127
fields are required (but no more than 255) - either save your XLS file as a
CSV file or create a MS Access table from the XLS file - importing either of
those.

Karl

PS - Am also assuming that your Excel '07 file has an .xls extension and not
..xlsx since Outlook (without BCM) will not import native "office '2007" file
types
___________________________________________________
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

Importing from excel to Outlook 1
Import Contacts From Excel to Outlook Not Working 3
How to easily migrate PST to Zoho account? 2
How do I add new Map Custom Fields or Maps. 1
Excel 2000 e-mail addresses into Outlook 2000 contacts 1
Saying "too much data" when transfering from excel to outlook. 1
problem importing Excel into outlook 2
Cannot import Excel file to MS Outlook - ODBC error, too many fie. 3

Back
Top