[R] RODBC and Excel Files

[Stephane Dray]

Sorry for previous post...
I find the reasons of my problems,

Windows used uppercase letter and i must precise it in my connection:
odbcConnect("dBASE Files",case="toupper")

And it is ok for excel Files.
For dbf files, there is another problem: by default, the size of the 
column is set to 255 in the function sqlSave (V7 in data.frame 
newname). This seems to be too much and when i change this value 
(e.g. v7=40) the problem is solved.

Sincerely,

-- 
Stéphane DRAY
---------------------------------------------------------------
Biométrie et Biologie évolutive - Equipe "Écologie Statistique"
Universite Lyon 1 - Bat 711 - 69622 Villeurbanne CEDEX - France

Tel : 04 72 43 27 56			   Fax : 04 78 89 27 19
       04 72 43 27 57 	   E-mail : dray at biomserv.univ-lyon1.fr 
---------------------------------------------------------------
ADE-4               http://pbil.univ-lyon1.fr/ADE-4/ADE-4F.html
---------------------------------------------------------------
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._