Importing Excel 07 file into Outlook

T

Tracey

I am trying to import excel file and got an ODBC error - too many fields
defined - what can I do?
 
V

Vince Averello [MVP - Outlook]

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.
 
K

Karl Timmermans

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
Access Subscript out of range when importing into access 2010 from excel 0
Import Contacts From Excel to Outlook Not Working 3
Saying "too much data" when transfering from excel to outlook. 1
importing from excel - contacts not showing up 1
Export Contacts from Excel and Map to User Defined Fields?? 1
How do I add new Map Custom Fields or Maps. 1
Cannot import Excel file to MS Outlook - ODBC error, too many fie. 3

Top