Issues in accessing CSV table data

[AnthonyCheesman1]

Hi - I'm having issues in getting ArcGIS to read a CSV file as a table.

The table is created as the output from a Python script I have written - partly because it provides a bit of flexibility in being able to view the table in Excel or similar, and partly because creating a table or features from Python using a cursor confuses me.

Anyway...

* The csv table contains XREF and YREF fields

* The csv file creates fine.

* The *first* time I add the table to an ArcGIS project, I can view all fields and attributes, create an XY event, and visualise the data

* Any *subsequent* times I add the data, some of the fields are not viewable (including the XREF field) and thus I can't create an XY event or view the data.

Any ideas as to why this could be occurring?

Thanks

[AnthonyCheesman1 · Accepted solution]

OK, I think I've answered my own question.

There's something funny going on with schema.ini in that a couple of fields get recreated. There must be a special character tripping it out somewhere.

Anyway, if I delete schema.ini, the problem goes away, at least until it appears again.

I suspect the long term fix will be to modify my script to create a FC and points rather than write a CSV and rely on then manually creating the XY event layer.

[BenVan_Kesteren1]

Nathan Duncan​ the schema.ini file rears its ugly head again!