Export to .dbf but....

1727
9
Jump to solution
10-27-2016 01:37 PM
JoeBorgione
MVP Emeritus

In the past I've exported ArcGIS database tables to .dbf format and then open them in Excel, save them as a .xls and send the 'data' to a non-gis user.

But in windows 10, how does one open a .dbf table?  I don't see .dbf  listed in the set associations window....

That should just about do it....
0 Kudos
1 Solution

Accepted Solutions
DanPatterson_Retired
MVP Emeritus

you can navigate to the folder where excel is installed and select it, or try to open excel, then select the file.  If you can open it once, then 10 seems to remember what you used to open it last time.

View solution in original post

0 Kudos
9 Replies
JayantaPoddar
MVP Esteemed Contributor

Are you able to Right-Click *.dbf > Open With > Microsoft Excel?

I think once you do it, .dbf would become available in Set Association extension list.



Think Location
JoeBorgione
MVP Emeritus

I right click; open with gives a lame list of apps, (adobe.  huh?) and directs me to the ms app store....

That should just about do it....
0 Kudos
DanPatterson_Retired
MVP Emeritus

you can navigate to the folder where excel is installed and select it, or try to open excel, then select the file.  If you can open it once, then 10 seems to remember what you used to open it last time.

0 Kudos
JoeBorgione
MVP Emeritus

I'll give it a try Dan.  Thanks.

That should just about do it....
0 Kudos
JoeBorgione
MVP Emeritus

As Dan suggests- open excel.  browse to .dbf location. Choose dBase Files.

That should just about do it....
PROBERT68
Frequent Contributor

I had the same thing a few months ago. What I did was to google it and found this. This is for Windows 7 but you should be able to find it for Windows 10.

How to change the default program a file opens with in Windows 7 

0 Kudos
DanPatterson_Retired
MVP Emeritus

the problem is, the optional programs that could open it aren't listed sometimes, and one has to know where the *.exe is located.  So... if you open a file using a specific program, then windows 10 puts it in the list of files that have opened it in the past, and as any good servant, offers it up next time as one that has been used in the past.

0 Kudos
PROBERT68
Frequent Contributor

That is what I did and it worked.

0 Kudos
DanPatterson_Retired
MVP Emeritus

Yes... the first time I tried to load a *.dbf, it wasn't even listed in the file extensions list as in Joe's picture.  I followed my suggestion rather than wade through the windows 7 stuff.  

This process has worked in all previous incarnations of windows that I think of.  It is a useful idea, should you wish to create your own file extension and have it loaded by a particular program.

Effectively, you would be the only one that could load it easily since the extension wouldn't appear on another person's machine as being able to be opened by anything.  Very effective for binary files... providing an extra level of security to slow down the 12 year old for an hour or so.

0 Kudos