[R] RODBC sqlFetch

juli g. pausas juli at ceam.es
Sat May 11 19:03:51 CEST 2002

Thanks for showing me how to use RODBC 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")) ,

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 G. Pausas
Centro de Estudios Ambientales del Mediterraneo (CEAM)
C/ C.R. Darwin 14, Parc Tecnologic,
46980 Paterna, Valencia, SPAIN
Tel: (+ 34) 96 131 8227; Fax: (+ 34) 96 131 8190
mailto:juli at ceam.es

GCTE Fire Network - http://www.gva.es/ceam/FireNetwork
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch

More information about the R-help mailing list