search for: bbaselineptqair

Displaying 1 result from an estimated 1 matches for "bbaselineptqair".

Did you mean: bbaselineptqaires
2012 Apr 20
1
odbcConnectExcel() fails to fetch all columns
Folks, Is there a parameter somewhere in RODBC that enables more columns to be retrieved from an Excel worksheet? # This next bit uses an undocumented call in RODBC z <- odbcConnectExcel("./BBaselinePtQaires_apr2011.xls") BQ <- sqlFetch(z, "BBaselinePtQaires") Gives me: z RODBC[1] And BQ 134 obs. of 59 variables I have all the rows in the worksheet but only the first 59 out of a total of 70 columns. I?m in RStudio 0.95.263 using RODBC 1.3-3 and R version 2.12.2 (2011-02-25)....