Re: [R] Reading only one Column of an excel file using RODBC

2013-11-05 Thread Baro
Yes, but I dont know how can I SELECT the infos from one column. Columns have no names in my excel. I tried it jo<-odbcConnectExcel2007("D:\\MA\\excel_mix_meiningen.xls") dfr <- sqlQuery(jo,"SELECT top 1 F1 FROM `Tabelle1$`") close(jo) dfr but I get an error: [1] "07002 -3010 [Microsoft][ODBC

Re: [R] Reading only one Column of an excel file using RODBC

2013-11-05 Thread Prof Brian Ripley
On 05/11/2013 09:18, Baro wrote: Hi experts How can I read only one column of an excel file using RODBC in r? The same way as for any other ODBC client: by selecting it in SQL. [[alternative HTML version deleted]] __ R-help@r-project.org