topic Re: Excel to Table not functioning in Data Management Questions

Excel to Table not functioning

AncaUrsu — Mon, 03 Jul 2017 13:26:56 GMT

Hello! I am trying to convert an Excel file to Table. Worked last night, not anymore. No error code, see screenshot. Ideas?

Re: Excel to Table not functioning

SarojThapa1 — Mon, 03 Jul 2017 13:43:08 GMT

Anca,

The error could be because of mismatched fields and data type. Make sure there is no space in the beginning of each FieldName, no space between FieldNames (for e.g. not Feature Name but Feature_Name). Make sure there are no annotations such as N/A in the field values especially if that field's data type is numeric.

If possible, show us a snapshot of your excel spreadsheet.

Re: Excel to Table not functioning

SarojThapa1 — Mon, 03 Jul 2017 13:48:55 GMT

I just noticed your excel file is in xlsx format. Save the excel file in xls format. You should have no issues provided there are no mismatched fields and data types.

Re: Excel to Table not functioning

JayantaPoddar — Mon, 03 Jul 2017 15:23:53 GMT

What version is your ArcMap?

Could you attach a sample of the excel sheet? I hope the table is simple, i.e., the first row of the excel contains the name of the fields, and no merged cells anywhere.

Re: Excel to Table not functioning

BlakeTerhune — Mon, 03 Jul 2017 16:40:31 GMT

Additionally, field names cannot begin with a number.