search for: tbls

...39;Data manipulation with R' book written by Phil Spector. It seems very straightforward, yet I get the same error everytime I try it, with different excel sheets and trying to tweek the code a bit. This is what I do: library(RODBC) sheet='X:\\example.xls' con=odbcConnectExcel(sheet) tbls=sqlTables(con) tbls$TABLE_NAME qry=paste("SELECT * FROM '",tbls at TABLE_NAME[1],"'", sep=" ") The error I get is: Error in paste("SELECT * FROM '", tbls at TABLE_NAME[1], "'", sep = " ") : trying to get slot "TAB...

....d)} .con <- try(close(.con), silent = T) if(inherits(.con, "try-error")) return(.con) .d <- .d[!names(.d) %in% drop] return(.d) } get.alltables <- function(db){ .con <- try(odbcConnectAccess(db), silent = T) if(!inherits(.con, "RODBC")) return(.con) .tbls <- try(sqlTables(.con)[["TABLE_NAME"]]) if(inherits(.tbls, "try-error")){close(.con); return(.tbls)} .con <- try(close(.con), silent = T) if(inherits(.con, "try-error")) return(.con) .tbls <- .tbls[-grep("^MSys", .tbls)] .d <- lapply(seq...

...mple in Phil Spector's book (p. 34), after creating a connection named con I did the following: > con RODBC Connection 3 Details: case=nochange DBQ=c:\temp\test.xls DefaultDir=c:\temp Driver={Microsoft Excel Driver (*.xls)} DriverId=790 MaxBufferSize=2048 PageTimeout=5 > tbls <- sqlTables(con) > tbls TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 c:\\temp\\test <NA> Sheet1$ SYSTEM TABLE <NA> 2 c:\\temp\\test <NA> Sheet2$ SYSTEM TABLE <NA> 3 c:\\temp\\test <NA> Sheet3$ SYSTEM TABLE...

...status major 2 minor 2.0 year 2005 month 10 day 06 svn rev 35749 language R Operating system: SuSE 10 Rainer ----------------- library(gstat) library(RMySQL) library(DAAG) m <- dbDriver("MySQL") con <- dbConnect(m, group = "renpatch_renosterbos") tbls <- dbListTables(con) runs <- 1:5 years <- seq(98, 0, -7) progress_end <- length(tbls) * length(runs) * length(years) progress <- 0 for (year in years) { fd <- paste("/home/rkrug/Documents/R/plots/Y", year, sep="") dir.create(fd, showWarnings=FALSE, recursive...

Can someone throw light on the following problem I am having with RODBC? There's an Excel file I am trying to read from, it has one sheet named 'nameclass'. Thanks in anticipation. Vishal Belsare > library(RODBC) > con = odbcConnectExcel(file.choose()) > tbls <- sqlTables(con) > tbls TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS 1 T:\\data\\in\\nameclass <NA> nameclass$ SYSTEM TABLE <NA> > qry = paste("SELECT * FROM '",tbls$TABLE_NAME[1],"'",sep="") > result...

...H69:H283 in sheet 2. v<-"http://www.statistics.gov.uk/elmr/01_09/downloads/Table1_07.xls" dest<-"C:/Data/onstest.xls" download.file(url=v,destfile=dest,mode="wb") library(RODBC) channel <-odbcConnectExcel(dest) qry <- paste("SELECT * FROM '",tbls$TABLE_NAME[2],"'",sep="") onstest <- sqlQuery(channel,qry) close(channel) very grateful for any help simeon [[alternative HTML version deleted]]

...Even though they can not do anything with them, I would still be nice if eth0.5 users could not see them at all. I do believe the offending rules: VlanNic="eth0.5" Vlan_mask="24" Vlan_net="192.168.254.0/$Vlan_mask" Vlan_Broadcast=192.168.254.255 $tbls -A Vlan-in -i $VlanNic -p udp -s $Vlan_net -d \ $Vlan_Broadcast --dport netbios-ns -j ACCEPT $tbls -A Vlan-in -i $VlanNic -p udp -s $Vlan_net -d \ $Vlan_Broadcast --dport netbios-dgm -j ACCEPT I have found that if I do not open up these two rules, domain users on eth0.5 c...

# Set everything else to deny all other network access (debug=1): $tbls -A dsl-for -j LOG --log-level $debug --log-prefix "dsl-for Everything Else " $tbls -A dsl-for -j DROP packets originating on my VLAN (eth0.5) destined for the Internet get logged with their IN/SRC, OUT/DST logged backwards. For instance, this is Cobian Backup (http://www.cobian.se/cobia...

...ing sqlTables but it seemed to break the connection. unless i've missed something, i cant see a solution to this on the help list. grateful for any help or pointers simeon # long way library(RODBC) filepath <- "C:/Data/workbook.xlsx" connect <- odbcConnectExcel2007(filepath) tbls <- sqlTables(connect) sheet1 <-sqlFetch(channel=connect,sqtable='sheet1') sheet2 <-sqlFetch(channel=connect,sqtable='sheet2') sheet3 <-sqlFetch(channel=connect,sqtable='sheet3') .. etc close(connect) [[alternative HTML version deleted]]

Hello, the following patches should get multidisk access working. The syntax accepted is the following: (hdx,y)/path/to/file where x is the disk number and start at 0 and the y is the partition number starting at 1. So (hd0,1) is the first partition of the first disk. the other accepted syntax is using MBR's 32 bits disk signature so for example: (mbr:0x12345678,2)/foo/bar would address