topic Re: Is there any way to view .accdb data in Pro? in ArcGIS Pro Questions

Is there any way to view .accdb data in Pro?

KamillePreto — Mon, 20 Apr 2020 15:22:28 GMT

I never use Microsoft Access for the work that I do, but I do know that GIS professionals would be able to open or convert the Access data into their GIS. I was sent a .accdb from somebody who needs a map created and web application and I am unfamiliar with what the steps look like from here. I am aware that .accdb are no longer able to open up in Pro (I read in a few forums), however, I feel like there has to be some way to get the data from an .accdb into Pro so I can save the layers as shapefiles or feature classes.

I tried to go to Properties of the .accdb and change the extension to .gdb, which worked. But it is not showing up as a file that is able to be pulled into Pro - I assume it's formatting related.

Can anybody help me?

This type of GIS-related work is above my skill set and I am definitely confused.

Re: Is there any way to view .accdb data in Pro?

JoshuaBixby — Mon, 20 Apr 2020 15:45:36 GMT

The short answer, not really. I assume you read Microsoft Access (.accdb) Support in ArcGIS Pro? The idea/request has been around for years, and Esri is now saying it is "In Product Plan" but they don't say when it will show up. There is also https://community.esri.com/community/open-platform-standards-and-interoperability/blog/2019/09/26/using-odbc-data-sources-in-core-arcgis-pro

Re: Is there any way to view .accdb data in Pro?

KamillePreto — Mon, 20 Apr 2020 15:51:27 GMT

Thanks Joshua. Yes I voted on that Idea earlier today as well during my research. I'm going to check out the second link you sent me.

So there is no way to convert the existing .accdb into something that Pro can read?

Re: Is there any way to view .accdb data in Pro?

JoshuaBixby — Mon, 20 Apr 2020 16:37:57 GMT

If you are willing to spend some money, there are several tools that various companies put out that convert entire Access databases to other formats, like SQLite, that ArcGIS Pro can read. I am not aware of any free or open-source tools that do entire DB migration.

If there aren't too many tables, then you could export tables as CSV or to Excel worksheets and then open them in Pro that way. If there are a lot of tables, you could script something similar.

One other idea, although convoluted, would be to convert an ACCDB to MDB and then use ArcGIS Desktop/ArcMap to convert/copy from MDB to FGDB.

Re: Is there any way to view .accdb data in Pro?

JoeBorgione — Mon, 20 Apr 2020 16:39:41 GMT

(posted just after Joshua's repsonse without seeing his...)You can always export your Access Table(s) to csv format and then use a table to table in Pro to bring the csv into a fgdb table. Be careful when you do that as you may need to manually adjust the field types during that process to maintain the original type.

Re: Is there any way to view .accdb data in Pro?

KoryKramer — Mon, 20 Apr 2020 16:48:29 GMT

OLE DB support is coming in the next release of Pro (2.6) which is scheduled for July. In a development build, I have created a connection to an .accdb file:

Re: Is there any way to view .accdb data in Pro?

JoeBorgione — Mon, 20 Apr 2020 17:04:31 GMT

That's going to make tons of people very, very happy!

Kory Kramer‌

Re: Is there any way to view .accdb data in Pro?

KoryKramer — Mon, 20 Apr 2020 17:07:41 GMT

Yes, we know

Re: Is there any way to view .accdb data in Pro?

JoshuaBixby — Mon, 20 Apr 2020 17:09:56 GMT

I agree, Joe. Given that ArcGIS Pro 1.0 was released 01/2015, it is still frustrating that it took Esri 5+ years to add functionality that ArcMap had before Pro was released.

Re: Is there any way to view .accdb data in Pro?

JoeBorgione — Mon, 20 Apr 2020 17:16:56 GMT

Who knows: maybe by 2025 we'll see a resurgence of the Personal Geodatabase...

Re: Is there any way to view .accdb data in Pro?

JoshuaBixby — Mon, 20 Apr 2020 17:39:09 GMT

What gets me is that the local/runtime geodatabase (*.geodatabase) is basically a geodatabase implemented within SQLite. ArcGIS Pro already reads them and writes them, Esri just won't let Pro use them like a functional/operational geodatabase.

Re: Is there any way to view .accdb data in Pro?

JamesBurn__LET__C_E_T___GISP__ — Tue, 21 Apr 2020 16:58:12 GMT

As external applications were mentioned, a potential free option could be to work it through MS SQL Server. You can install the express version (free) and it can read/import both mdb and accdb. These tables in turn can then either be linked to directly from ArcPro or export to CSV etc. depending on where you want to go with it. Generally speaking I haven't had any issue moving between MS Access and MS SQL Server with respect to field types etc. I agree that it's a bit of a big hammer for a small nail, but the you do end up with the advantages of having a local SQL Server instance.

Re: Is there any way to view .accdb data in Pro?

Page_Charles — Wed, 22 Apr 2020 01:45:20 GMT

I beg to differ. I'll refrain from using the language to "convert a file to read an ACCDB in PRO". However, I'm very optimistic and almost sure the data can be integrated into ArcGIS Pro. There is a fix to resolve your issue.

Re: Is there any way to view .accdb data in Pro?

Zeke — Wed, 22 Apr 2020 11:55:49 GMT

Another option would be to export the tables in Access to Excel or csv and import those to Pro.

Re: Is there any way to view .accdb data in Pro?

MiguelMartinez2 — Wed, 22 Apr 2020 13:41:45 GMT

When ArcMap was release back on 1999, half of the ArcView tools were missing. And then year after year ESRI made these big announcements of the new things coming to ArcMap and most of the new things were tolls already available in ArcView. The same thing happens with the release of ArcGIS Pro, half of the ArcMap tolls were missing and then for the past years they have been incorporated to Pro as a new thing. That’s why users like me are still saying, “what were they thinking???”. Of course, to be fair, there were new tools in ArcMap that did not exist in ArcView, and there are tools in ArcGIS Pro that never existed in ArcMap. But the point is, you don’t release a new version of anything taking away past functionalities just to say you have a new software. You keep adding up and keep having your customers happy. So, what can we expect in the future when ArcGIS Pro is replaced by a new software, that we are going to have, again, half the tools missing? And now that ESRI used the “Pro” suffix in this latest version, what would they called the next software, Super Pro, Mega Pro, Pro Pro??? The answer to all this is very simple, talk to your customers before and find out what they really want to see in a new installment. Do focal groups, do beta testing, do surveys, and most of all, be users of your own products so that you can really understand what we as users want in future releases.

Re: Is there any way to view .accdb data in Pro?

JasonSmith4 — Wed, 22 Apr 2020 15:59:41 GMT

OMG Kory Kramer‌ you don't know HOW much you just made my day, month, YEAR! MANY of us have been waiting with baited breath for this functionality. YAY !!!!!! I'm going out celebrating tonight! LOL

Re: Is there any way to view .accdb data in Pro?

JasonSmith4 — Wed, 22 Apr 2020 16:12:57 GMT

Hey Greg, while this is true. It almost ALWAYS leads to fields getting set with incorrect data types. For instance, Zip Code fields when imported from Excel or CSV usually come in as a number field, when they should really be text/string. Same with company IDs that are numeric in nature, but should be treated a text/string. By having native Access database tie-ins, as long as the data type is set correctly in the Access table, then it saves a step of having to make sure the fields coming in are set to the correct type in ArcGIS Pro.

Re: Is there any way to view .accdb data in Pro?

JoeBorgione — Wed, 22 Apr 2020 17:51:37 GMT

I use the table to table tool in Pro to convert CSVs into FGDB tables; you can specify how each field is handled with that tool. That's really helpful for what you are describing, and especially so with text fields that otherwise default to 8,000 characters. Excel to table may be different but I try to stay away from them when it comes to ArcGIS...

Re: Is there any way to view .accdb data in Pro?

BranislavBlagojevic — Thu, 23 Apr 2020 01:06:56 GMT

James,

Microsoft SQL Server is free but people here discussing direct reading MS Access data from ArcGIS Pro software (Basic, Standard and Advanced), not Enterprise Solution; not about SDE and not about ArcGIS Server. As far as I know from ArcGIS Pro it is not possible to even connect to SQL Server Express, as it was (I haven't tested in ArcGIS Dektop 10.8) possible from ArcMap/ArcCatalog (Personal SDE). So it's not free!

Re: Is there any way to view .accdb data in Pro?

BranislavBlagojevic — Thu, 23 Apr 2020 01:11:25 GMT

Kory,

Thanks for the nice news!