Select to view content in your preferred language

Personal GDB(.mdb) import tool

12299
27
04-20-2018 09:32 AM
Status: In Product Plan
Labels (1)
RobertGraham
Occasional Contributor

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

27 Comments
AlfredBaldenweck

Kind of duplicate of this: Conversion Tool: Convert from archaic formats to m... - Esri Community

100% agree. Esri says that it isn't possible to do, but that's not the case. 

  1. FME and Data Interoperability can do it (except Access 97 mdbs)
  2. QGIS can do it as well (except Access 97 mdbs)

There is no reason why there can't be a free tool that just blind-converts a given mdb. In the case of an Access 97 mdb, ArcMap is literally the only program that can open these files, period, so that's kind of a lost cause, but...

 

I'd also like to add that whenever I ask about this, the answer is always "We need to focus on the future and there isn't enough need for it" and yet about every 6 weeks someone new asks about it here.

ValeriaChavez
Status changed to: Needs Clarification

Hi @Howatt_PeterKing! Thanks for submitting this Idea.

I believe the script tool you are referring to is the one presented in the blog by @ElaineEvans and @MikeJensenMigrating Data: Tools to migrate a personal geodatabase to a file or mobile geodatabase. Could you confirm that's the case? Or are you referring to a different script shared through technical support?

If it is the tool presented in the blog above, is your Idea about accessing this script tool with an ArcMap Basic license? According to the FAQs, the ArcGIS Data Interoperability license is only required for accessing the PGDB to FGDB tool when you don't have access to ArcMap Standard or Advanced. 

JoshuaBixby

@ValeriaChavez , I believe the OP is seeking something that doesn't require ArcGIS Desktop/ArcMap.  ArcMap will be fully retired in 9 months, and at some point people won't even be able to download to install it anymore, so there needs to be a Pro-only solution to this issue.

AlfredBaldenweck

Yeah, as it is, I was told I couldn't get ArcMap with a personal license last summer. There is a HUGE amount of data stored in archaic formats (coverages, MDBs, e00 files) across my organization and many others.

ValeriaChavez
Status changed to: Open
 
SSWoodward
Status changed to: In Product Plan
 
xingchenc

good news, finally!