Re: [R] odbcConnectExcel() fails to fetch all columns

2012-04-20 Thread andrija djurovic
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

Re: [R] odbcConnectExcel() fails to fetch all columns

2012-04-20 Thread Jeff Newmiller
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 --

[R] odbcConnectExcel() fails to fetch all columns

2012-04-20 Thread Andrew Roberts
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