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
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
I have been trying to read some data from an Excel workbook without
success. The workbook is in .xls format and has multiple sheets, one
with the sheet name Data, which is the sheet I wish to read from. One
complication is that the header row of this sheet is comprised of
dropdown boxes.
I tr
Hi,
I'm able to establish a successful odbc connection using RODBC 1.3-2 on Win
7 and R 2.12.0. But I'm getting the following error message when I try to
save a data frame into the debase as shown below.
library(RODBC)
bbdb <- odbcConnect("bbdb")
odbcGetInfo(bbdb) # returns ok
sqlSave(bbdb, USAr
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-
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-
Good morning,
I have some problems installing RODBC to R in a linux cluster. My R version
is:
R version 2.12.0 (2010-10-15)
Platform: x86_64-unknown-linux-gnu (64-bit)
I get the following error:
> install.packages('RODBC')
Installing package(s) into
'/home/jorgehou/R/x86_64-unknown-linux-gnu-libr
7 matches
Mail list logo
