Geoblogger’s Blog

Geography, GIS, history, landscape, life

ArcGIS and Excel 2007

Ahhhrg. I just understood that my fancy Excel in Office 2007 does not support dBase-files. This was probably going to happen at one time or another, fewer and fewer program were using dbf, but ESRI has inArcGIS been using it a lot so I have a bunch of files that now cannot easily be read in Excel 2007 and furthermore I cannot export to dbf for use in ArcGIS. I have an older version of ArcGIS installed on my laptop – 9.1. If I upgrade to for instance 9.3 there is a way of importing xls-files from Office 2007. Thank you very much ESRI… Reading excel-files was easy in MapInfo years ago. It even works with strange looking characters. (OK I know other formats can be read as well txt, csv etc, but it all takes time, time I do not have). Many have figured out this problem a year ago (I am slow…) There are also some small programs out there to transform from dbf to xls/xlsx  and vice vers of course and a very nice litle script. But honestly Microsoft why abandon dbf? Was it really that expensive to keep it as a possible file?

Advertisements

Filed under: GIS, , , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: