Print this page

Data Extension Import fails due to "Invalid field count"

Knowledge Article Number 000213785

When you set up an Import activity using the "Map by Ordinal" option but you don't select "Has Column Headings," the Import assumes that the first row of your file are column headings. If the first row has more columns than the rest of the file, the import will fail. Here's how to fix the problem:



Fix "Invalid field count" Import failures

  • Add column headers to the file being imported when importing with "Map by Ordinal" and select Has Column Headings.
  • Edit the file so each row has the same number of columns as the first row. 
  • Move the first row of the file to another row later in the file so the Import activity use the new first row's columns for the process.

promote demote