Displaying 1 result from an estimated 1 matches for "ftbragg_geodatabase_auburnunv".
2009 Aug 16
0
large list from mdb.get - change labled atomic to double
...le was
# generated to avoid that accented table column names are
# getting lost.file first
#mdbtools also has to be working
Sys.setlocale('LC_ALL','C')
Sys.setenv(PATH=paste(Sys.getenv('PATH'),'/sw/bin',sep=':'))
d <- mdb.get('/Users/sefick/Desktop/FtBragg_GeoDataBase_AuburnUNV.mdb')
f <- list()
for(i in 1:length(d)){
a <- as.integer(d[[i]][,1])
b <- cbind(a, d[[i]])
colnames(b)[1] <- "ID"
f[[i]] <- b
}
names(f) <- names(d)
#create database in sqlite3 before using this script
library(RSQLite)
drv <- dbDriver("SQLite")
con...