search for: successrates

...t Gunter Version: 2.0.0 patched OS: Win2000 Submission from: (NULL) (192.12.78.250) The TRUE/FALSE options of the colnames argument in sqlFetch (RODBC) seem to be reversed, at least for .xls files. ## z is a connection to an xls workbook opened by odbcConnectExcel() > dat<-sqlFetch(z,'SuccessRates',colnames=FALSE) > dat[1:5,] RecID Name Run Grams Lost Run (80L) 1 NA Activase 117 839.91 0 2 NA Activase 118 860.52 0 3 NA Activase 119 921.23 0 4 NA Activase NA NA 1 5 NA Activase 120 722.62 0 >...

Hi, First off, let me state that _YES, I am fully aware that what I am doing is insane, prone to major havoc and bad for general health_ :-)) Scenario: My GF needs an analog modem to use with her banking software (sodding backs don't supply a decent web-application for company use). I am experimenting to see if we can get it to work (albeit slow) trough our ATA186 talking g711 to

...lFetch(z,"'Success Rates$'") ## But > dat [1] "[RODBC] ERROR: Could not SQLExecDirect" [2] "37000 -1002 [Microsoft][ODBC Excel Driver] ''Success Rates$'$' is not a valid name. .. blah blah When I removed the space from the sheet name -- "SuccessRates" -- all worked smoothly as documented. Cheers, Bert -- Bert Gunter Genentech Non-Clinical Statistics South San Francisco, CA "The business of the statistician is to catalyze the scientific learning process." - George E. P. Box