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

Hi experts How can I read only one column of an excel file using RODBC in r? [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide

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

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

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

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 Excel