https://community.esri.com/t5/arcgis-pro-ideas/access-fgdb-data-dynamically-from-excel/idi-p/1538901 <P>Background:&nbsp;<A href="https://community.esri.com/t5/data-management-questions/store-geoprocessing-outputs-in-a-format-accessible/m-p/1529872/highlight/true#M45358" target="_self">Store geoprocessing outputs in a format accessible to ArcGIS Pro and Excel</A></P><P>Idea: An Excel driver to access file geodatabase data, similar to ODBC, but using the FGDB API. Non-concurrent access, read-only.</P><P>Explanation: Need a place to store one-off enterprise geodatabase geoprocessing outputs that can be accessed in Excel by non-GIS staff, as well as in ArcGIS Pro. Unfortunately, there don't seem to be any reputable SQLite Excel drivers for using mobile geodatabases. Further, file geodatabases are Esri's most supported, flagship data type. It would be great to be able to dynamically access FGDB data in Excel instead of making additional copies of the data. The ArcGIS ecosystem is very powerful, but <STRONG>copies of data are where GIS people get into trouble.</STRONG> Microsoft would never create an FGDB driver, so it would have to be made by Esri.</P><P>Geoprocessing outputs and file geodatabases are the backbone of ArcGIS Pro. It would be very helpful to have full access to our GP/FGDB data using industry-standard tools like Excel.</P> Mon, 16 Sep 2024 18:29:37 GMT Bud 2024-09-16T18:29:37Z https://community.esri.com/t5/arcgis-pro-ideas/access-fgdb-data-dynamically-from-excel/idi-p/1538901 <P>Background:&nbsp;<A href="https://community.esri.com/t5/data-management-questions/store-geoprocessing-outputs-in-a-format-accessible/m-p/1529872/highlight/true#M45358" target="_self">Store geoprocessing outputs in a format accessible to ArcGIS Pro and Excel</A></P><P>Idea: An Excel driver to access file geodatabase data, similar to ODBC, but using the FGDB API. Non-concurrent access, read-only.</P><P>Explanation: Need a place to store one-off enterprise geodatabase geoprocessing outputs that can be accessed in Excel by non-GIS staff, as well as in ArcGIS Pro. Unfortunately, there don't seem to be any reputable SQLite Excel drivers for using mobile geodatabases. Further, file geodatabases are Esri's most supported, flagship data type. It would be great to be able to dynamically access FGDB data in Excel instead of making additional copies of the data. The ArcGIS ecosystem is very powerful, but <STRONG>copies of data are where GIS people get into trouble.</STRONG> Microsoft would never create an FGDB driver, so it would have to be made by Esri.</P><P>Geoprocessing outputs and file geodatabases are the backbone of ArcGIS Pro. It would be very helpful to have full access to our GP/FGDB data using industry-standard tools like Excel.</P> Mon, 16 Sep 2024 18:29:37 GMT https://community.esri.com/t5/arcgis-pro-ideas/access-fgdb-data-dynamically-from-excel/idi-p/1538901 Bud 2024-09-16T18:29:37Z