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)....