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 <ripley@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,                  ripley@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]]

