Re: [R] Problem with RODBC

2011-07-20 Thread David Scott
On 20/07/11 18:56, Dieter Menne wrote: David Scott-6 wrote: I have been trying to read some data from an Excel workbook without success. ... > faults<- sqlFetch(channel, sqtable = 'Data', +colnames = FALSE, as.is = TRUE) > faults [1] "HY001 -1040 [Microsoft][ODBC Excel

Re: [R] Problem with RODBC

2011-07-19 Thread Dieter Menne
David Scott-6 wrote: > > I have been trying to read some data from an Excel workbook without > success. > ... > > faults <- sqlFetch(channel, sqtable = 'Data', > +colnames = FALSE, as.is = TRUE) > > faults > [1] "HY001 -1040 [Microsoft][ODBC Excel Driver] Too many fields de

Re: [R] problem with RODBC installation

2010-11-04 Thread Peter Dalgaard
On 11/04/2010 08:14 AM, Jørgen Blystad Houge wrote: ... > '/tmp/Rtmpgb1Nxz/downloaded_packages' > Warning message: > In install.packages("RODBC") : > installation of package 'RODBC' had non-zero exit status > > I found some info on it here: > http://r.789695.n4.nabble.com/Problem-installing-

Re: [R] problem with RODBC installation

2010-11-04 Thread Prof Brian Ripley
Please read the RODBC manual (which comes with it). You (or the cluster owner) need to install unixODBC, and if installing from RPMs etc, something like unixODBC-devel. Please also note the R posting guide - no HTML mail, use an appropriate list (R-sig-db or R-devel here as this is about non-