topic Re: Issues with opening .DBF extensions in Excel 2016 in ArcGIS for Office Questions

Issues with opening .DBF extensions in Excel 2016

StuartBailey — Tue, 10 Dec 2019 01:21:05 GMT

Issues with opening .DBF extensions in Excel 2016 .

Recently upgraded all machines with Win 10 build 1905 and office 2016 64 bit

now finding that Esri users can no longer open these .dbf files unless they use a work around

by opening excel first then browse for the file using the all files filter.

I had this working by adding the extension and the association in win 7 64 bit and office 2016 with a registry hack.

this no longer works with win 10 / office 2016 64 bit.

why is this extension required for something that is basically a source file for >. shp files

couldn't this requirement be created with a standard extension (XML /XMLS Etc) that is compatible with current OS and Office software?

having to a create the extension then add the association as in the past now only to find this no longer works either.

creates down time for users and hands of a resolvable issue and further workload to IT support.

Re: Issues with opening .DBF extensions in Excel 2016

DanPatterson_Retired — Tue, 10 Dec 2019 02:34:04 GMT

Table to Table and Table to Geodatabase are the options for bringing into ArcGIS Pr

Then Table to Excel if you need go to excel

Converting the shapefiles to file geodatabase featureclasses would make it easier

An overview of the To Geodatabase toolset—Conversion toolbox | ArcGIS Desktop

Feature Class to Feature Class—Conversion toolbox | ArcGIS Desktop

Table To Geodatabase—Conversion toolbox | ArcGIS Desktop

and

Table To Excel—Conversion toolbox | ArcGIS Desktop

Re: Issues with opening .DBF extensions in Excel 2016

StuartBailey — Tue, 10 Dec 2019 07:39:57 GMT

Hi Dan

Thank you for the reply greatly appreciated , I’ll pass this onto staff and see how we go.

Best regards

Stuart Bailey

Information Systems Manager

Anangu Pitjantjatjara Yankunytjatjara

PMB 227 UMUWA

via Alice Springs NT 0872

Ph:

Mobile: 0488202046

Satelitte Ph: 0147180907

mailto:Infosys@Anangu.com.au

<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2FAPY-Lands-Anangu-Pitjantjatjara-Yankunytjatjara-1466117813680902%2F&data=02%7C01%7Cinfosys%40anangu.com.au%7C3d46cb1137694f2a4c2b08d768a4dff0%7Ca1240eb104ae4a888522072b2ca6f466%7C0%7C0%7C637092929674880551&sdata=%2BgfMw8LMWtTOEyt9UX6Z5qj3Vv31%2BotUx2ri1TnB4xs%3D&reserved=0>Follow APY on Facebook

APY Website: www.anangu.com.au<https://aus01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.anangu.com.au%2F&data=02%7C01%7Cinfosys%40anangu.com.au%7C3d46cb1137694f2a4c2b08d768a4dff0%7Ca1240eb104ae4a888522072b2ca6f466%7C0%7C0%7C637092929674890543&sdata=Xd5IhA%2FsiEkBIjKegJCYmI35iyLMJ8xIlif%2Fu8AZMk8%3D&reserved=0>