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 Driver] Too few parameters.
Expected 1."
[2] "[RODBC] ERROR: Could not SQLExecDirect 'SELECT top 1 F1 FROM
`Tabelle1$`'"
On Tue, Nov 5, 2013 at 2:33 AM, Prof Brian Ripley <rip...@stats.ox.ac.uk>wrote:
> 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 mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting guide http://www.R-project.org/
>> posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>>
>
> Please do (no HTML, a reproducible example and tell us what you tried).
>
>
>
> --
> Brian D. Ripley, rip...@stats.ox.ac.uk
> Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/
> University of Oxford, Tel: +44 1865 272861 (self)
> 1 South Parks Road, +44 1865 272866 (PA)
> Oxford OX1 3TG, UK Fax: +44 1865 272595
>
> ______________________________________________
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/
> posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
[[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 http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
