SQLite for ArcGIS Pro FTW

I work in an Esri shop. My workflow includes periodic ingestion of MS Access and shapefile data. ArcGIS Pro doesn’t recognize Access. This has caused me to stick with ArcMap for one particular process. Esri’s suggested alternative to Access (“Use Excel”) has proven problematic for me to use with Pro for a variety of reasons.

Enter SQLite, which I wish I had tried sooner. Pro works with SQLite. Unlike Excel, SQLIte does not try to guess your fields’ data types (though it will if you ask). Access ⇒ CSV ⇒ SQLite ⇒ ArcGIS Pro is my new workflow. I haven’t opened ArcMap in a while.

Back in February 2019 I used Pro instead of Map for a full month, as a test. I went back to hybrid Map/Pro after that, until now. I may never open ArcMap again.