search for: bdades

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...