Hi.
I use RODBC for importing Excel files quiet often and never got the
similar problem.
Have you tried with sqlQuery?
>>z <- odbcConnectExcel("./BBaselinePtQaires_apr2011.xls")
BQ <- sqlQuery(z, "select * from [BBaselinePtQaires$]")
Andrija
On Fri, Apr 20, 2012 at 11:57 PM, Jeff Newmiller
wr
Excel is not a database, and the Excel ODBC driver is extremely limited. Put
your data in a CSV file or a SQL database (even a Jet database is a step up
from Excel).
http://www.stata.com/support/faqs/data/odbc_excel.html
--
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 1
3 matches
Mail list logo