SQLite ODBC driver — Connect to mobile geodatabase from outside of ArcGIS, such as Excel

[Bud]

Can anyone recommend a specific SQLite ODBC driver? For the purpose of connecting to a mobile geodatabase using non-ArcGIS programs like Excel.

Use case: Store geoprocessing outputs in a format accessible to ArcGIS Pro and Excel

[Bud]

Has anyone used this SQLite ODBC driver? http://www.ch-werner.de/sqliteodbc/ 

[AZendel]

I have. You can read the SQLite / Mobile GDBs pretty well when linked into Access. But you cannot update any rows. That driver doesn't have the spatial libraries in it. In many RDBMs, and update is often an insert followed by a delete (the old version of the row). This ODBC driver doesn't know how to write geometries.  Another snafu when trying to use this driver (or maybe SQLite DBs in general) is that Access treats all text fields as "long text" or "memo" fields. Access won't join on those fields. These two limitations make it pretty much a no go for the workflows I was hoping for. 

[Bud]

@AZendel Interesting. My use case is Excel, not MS Access. I wonder if Excel behaves any differently.