I'm working on an integration project that is providing data from our billing system to ArcGIS. Field names can include spaces which are acceptable in SQL Server if enclosed in brackets e.g.
Our GIS administrator tells me that ArcGIS can't handle spaces in field names. I need to rename all fields to use an underscore or remove spaces. Is this correct? Are there any viable workarounds?
E.g. Create a view on each table and provide an alias.
Can ArcGIS use a query rather than attach to a table directly and substitute names on the fly?
"Select [Street name] as StreetName from Table1"