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

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

Bud — Fri, 30 Aug 2024 14:11:55 GMT

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

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

Bud — Fri, 30 Aug 2024 15:04:20 GMT

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

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

AZendel — Tue, 19 Nov 2024 20:32:12 GMT

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.

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

Bud — Tue, 19 Nov 2024 20:46:27 GMT

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