Displaying 2 results from an estimated 2 matches for "bdades".
Did you mean:
xdades
2002 May 11
2
RODBC sqlFetch
...ODBC and odbcConnect.
Now works nicely. The question I've got now is:
noms <- list.files(pattern=".DBF")
# removing extension names:
noms <- sapply(noms, function(x) as.character(strsplit(x,".DBF")) ,
USE.NAMES=F)
for (i in 1:length(noms)) {
s <- sqlFetch(bdades, noms[i])
# etc.
}
But it seems that sqlFetch() doesn't accept the name noms[i]. Neither
paste(noms[1], sep = "").
Any suggestion for workaround?
Thanks in advance
Juli
--
Juli G. Pausas
Centro de Estudios Ambientales del Mediterraneo (CEAM)
C/ C.R. Darwin 14, Parc Tecnologic,
469...
2002 May 10
2
RODBC for importing dbf
...data from a dbf file to R, by
saving the data as csv, for instance.
However, I have several hundreds of files to do that. So, I thought of
using RODBC to read the dbf files and save it as data.frame. However, I
cannot even start (this is my first time using such package):
> library(RODBC)
> bdades <- odbcConnect("prova.DBF")
Warning message:
ODBC connection failed in: odbcConnect("prova.DBF")
> dir(pattern="pr")
[1] "prova.DBF"
My idea was to use sqlFetch(bdades) to create an R data.frame.
I'm using R on Windows. I can open the file prova.DB...