If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
Too many fields defined error on import
I'm trying to import contact data from an excel spreadsheet (the data is
actually from ACT V8) with 27 columns and about 1300 rows. I get the error message "Too many fields defined" and don't get to map my fields. It looks like it's trying to get to the place to map the fields. Is there a limit on number of columns or rows? What can I do? |
Ads |
#2
|
|||
|
|||
Too many fields defined error on import
Yes there is a limit to the number of Excel rows (believe the number is 127
if memory serves but definitely somewhere in the 120-127 range - just forget the exact number off hand). Your problem more likely than not is that the named range is incorrect and has included far more columns than required. Either correct the named range or save your file as a CSV file and import that into Outlook. 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 "KJ" wrote in message news I'm trying to import contact data from an excel spreadsheet (the data is actually from ACT V8) with 27 columns and about 1300 rows. I get the error message "Too many fields defined" and don't get to map my fields. It looks like it's trying to get to the place to map the fields. Is there a limit on number of columns or rows? What can I do? |
#3
|
|||
|
|||
Too many fields defined error on import
Thank you - you were correct that there were too many columns in my range. I
brought that down to 25 and the import worked. You mentioned that the max number of rows is 120-127. It must be higher than that - I was able to import 975 rows at once. Still don't know the limit, but at least it's more than 127! Thanks for your help, Kirsten "Karl Timmermans" wrote: Yes there is a limit to the number of Excel rows (believe the number is 127 if memory serves but definitely somewhere in the 120-127 range - just forget the exact number off hand). Your problem more likely than not is that the named range is incorrect and has included far more columns than required. Either correct the named range or save your file as a CSV file and import that into Outlook. 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 "KJ" wrote in message news I'm trying to import contact data from an excel spreadsheet (the data is actually from ACT V8) with 27 columns and about 1300 rows. I get the error message "Too many fields defined" and don't get to map my fields. It looks like it's trying to get to the place to map the fields. Is there a limit on number of columns or rows? What can I do? |
#4
|
|||
|
|||
Too many fields defined error on import
Sorry - my response in the first paragraph should have read "number of Excel
columns" not rows as per cause of problem identified in second paragraph. 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 "KJ" wrote in message ... Thank you - you were correct that there were too many columns in my range. I brought that down to 25 and the import worked. You mentioned that the max number of rows is 120-127. It must be higher than that - I was able to import 975 rows at once. Still don't know the limit, but at least it's more than 127! Thanks for your help, Kirsten "Karl Timmermans" wrote: Yes there is a limit to the number of Excel rows (believe the number is 127 if memory serves but definitely somewhere in the 120-127 range - just forget the exact number off hand). Your problem more likely than not is that the named range is incorrect and has included far more columns than required. Either correct the named range or save your file as a CSV file and import that into Outlook. 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 "KJ" wrote in message news I'm trying to import contact data from an excel spreadsheet (the data is actually from ACT V8) with 27 columns and about 1300 rows. I get the error message "Too many fields defined" and don't get to map my fields. It looks like it's trying to get to the place to map the fields. Is there a limit on number of columns or rows? What can I do? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
import contacts using user-defined fields | dslocum | Outlook - Using Contacts | 3 | March 10th 08 01:15 AM |
Problems with Custom Sub to Import to User-Defined Fields | dch3 | Outlook and VBA | 3 | November 11th 06 05:52 PM |
Lost data in user defined fields after performing an import | Eddie | Outlook - Using Forms | 1 | November 7th 06 05:13 PM |
Import Error with Excel - Too many fields defined | RealGomer | Outlook - Calandaring | 2 | October 26th 06 11:18 PM |
Can I map to user-defined fields when I import an address list? | stephanienyc | Outlook - Using Contacts | 1 | September 19th 06 02:16 PM |