topic Message: There was an error trying to process this table in Data Management Questions

Message: There was an error trying to process this table

DianneFishel — Tue, 30 Aug 2011 13:57:33 GMT

Hi,
Last week I was able to successfully geocode and rematch addresses. Today after I succesfully imported two Excel file, I get an error message "There was an error trying to process this table" when I right click on the file name after selecting the street, city, state and zip code.

What I am doing wrong? It worked before!

Thanks,
Dianne

Re: Message: There was an error trying to process this table

JoeBorgione — Tue, 30 Aug 2011 17:59:59 GMT

Check the field names in the spreadsheet and make sure they don't have any spaces or special characters.

Re: Message: There was an error trying to process this table

JackMcKinnon — Sun, 11 Sep 2011 22:25:22 GMT

Also watch out for one or more empty rows at the bottom of the address table. This one perplexed me for a while when using a table which otherwise complied with the rules.

Re: Message: There was an error trying to process this table

KeriBlough — Wed, 14 Dec 2011 14:01:56 GMT

I received the same error message during the geocode process. The output was always created successfully, but the rematch address window was never available. After reading the previous post, I set a print area in the spreadsheet to include only the cells that should be included in the output. This time, when attempting to geocode, I selected the print area worksheet and all of the records geocoded without the error message and the rematch window opened.