Personal GDB(.mdb) import tool

2050
5
04-20-2018 09:32 AM
Status: Open
Labels (1)
RobertGraham
New Contributor III

Since ArcGIS PRO currently does not have a native method for reading data from Microsoft access databases(.mdb) we need a tool at least to import the data into a file geodatabase.  It would be best to natively read the personal geodatabases instead of importing.  

Many companies still use the personal geodatabase because of the ease of development in MS access for forms and reports.  

Please vote up this idea.Microsoft Access (.accdb) Support in ArcGIS Propug list #pug puc

5 Comments
KoryKramer

Are you currently using ArcMap?  Just curious why the workflow wouldn't be to import the mdb contents into gdb in ArcMap/ArcCatalog.  Then use the gdb in Pro?

MichaelVolz

That workflow might make ArcMap users NOT want to transition to Pro though where everything can be done in one application instead of two.

RobertGraham

Kory,

  I do have ArcMap and ArcCatalog and could do the conversion.  But many of us are interested in testing for full parity so we can transition to a PRO primarily production environment.  This is one of those critical functionality missing from PRO that will have an impact on GIS users that ESRI may not recognize.  The personal GDB is a good storage medium with access by other non-GIS applications that make it very useful without the need for synchronization of files to switch formats between applications.

JoabelBarbieri

This is extremely important. A python tool a GP or anything in PRO  ...we need to be able to pull personal gdb into PRO without having to keep ArcGIS Desktop installed. Even a conversion tool that gets a mdb and converts into gdb or geopackage.

Some users are recurring to QGIS to read mdb. That shouldn't be acceptable from ESRI's standpoint.

LyonMNGIS

I would understand if ArcGIS Pro cannot read Personal Geodatabases or Access Databases....   but it would be nice if ESRI included a separate tool tool that will convert Personal Geodatabases to a File Geodatabase.  For all I care the we could run a 32 bit tool outside of ArcGIS Pro...  I just don't want to keep an old copy of ArcMap around so that I can access data that is stored in older formats.

Specifically my situation is that the NRCS web soil survey stores data in an access database.  ArcMap can read that database and import the data into a File Geodatabase while ArcPro cannot.

 

Thanks!