OpenOffice is a non-programming Open solution. The spreadsheet in OpenOffice
still can export DBFs, unlike castrated newer versions of Excel.
Rob
-----Original Message-----
From: Phil Hurvitz
Sent: Sunday, May 25, 2014 5:05 PM
To: KT ; UW - GIS Discussion and Support
Subject: Re: [UW-GIS-L] conversion to dbf in excel 2007
You could use R on windows.
Assuming the spreadsheet has your data in Sheet1 and is formatted as a
simple row x column matrix without free-form headers or other junk,
library(RODBC)
library(foreign)
xls <- odbcConnectExcel2007("Book1.xlsx")
dat <- sqlFetch(xls, "Sheet1")
write.dbf(dat, file="Book1.dbf")
-P.
**************************************************************
Philip M. Hurvitz, PhD | Research Assistant Professor | UW-CBE
Urban Form Lab | 1107 NE 45th Street, Suite 535 | Box 354802
University of Washington, Seattle, Washington 98195-4802, USA
[email protected] | http://gis.washington.edu/phurvitz
"What is essential is invisible to the eye." -de Saint-Exupéry
**************************************************************
On 2014-05-25 13:46, KT wrote:
hi,
I have a *xls file in which there are seismicity locations. I want to
convert this xls file to a dbf file in excel 2007. But, I know that it
is impossible in excel 2007. So I am looking for a free software for
this conversion application. Any help would be greatly appreciated....
_______________________________________________
Uw-gis-l mailing list
[email protected]
http://mailman13.u.washington.edu/mailman/listinfo/uw-gis-l
_______________________________________________
Uw-gis-l mailing list
[email protected]
http://mailman13.u.washington.edu/mailman/listinfo/uw-gis-l
_______________________________________________
Uw-gis-l mailing list
[email protected]
http://mailman13.u.washington.edu/mailman/listinfo/uw-gis-l
