Re: [R] RODBC: Trying to read an Excel file

2009-06-25 Thread Duncan Murdoch
On 6/25/2009 7:20 AM, John Sorkin wrote: R 2.8 Windows XP Excel 2003 I am trying to read an Excel spread sheet. I have looked at the RODBC help pages and am having trouble setting up code that will work. My code and the results are pasted below: jo<-odbcConnectExcel("i:\\all\\sorkinjohn\\st

Re: [R] RODBC: Trying to read an Excel file

2009-06-25 Thread Rodrigo Aluizio
oject.org] Em nome de John Sorkin Enviada em: quinta-feira, 25 de junho de 2009 08:21 Para: r-help@r-project.org Assunto: [R] RODBC: Trying to read an Excel file R 2.8 Windows XP Excel 2003 I am trying to read an Excel spread sheet. I have looked at the RODBC help pages and am having trouble sett

Re: [R] RODBC: Trying to read an Excel file

2009-06-25 Thread Jorge Ivan Velez
Dear John, Try this: require(RODBC) spreadsheet <- "Sheet1" # please change this to your needs channel <- odbcConnectExcel("i:\\all\\sorkinjohn\\stats\\silvermannatalie\\NEMOcombined06-24-09.xls") mydata <- sqlFetch(channel, spreadsheet) odbcClose(channel) # attach(mydata) mydata HTH, Jorge O

[R] RODBC: Trying to read an Excel file

2009-06-25 Thread John Sorkin
R 2.8 Windows XP Excel 2003 I am trying to read an Excel spread sheet. I have looked at the RODBC help pages and am having trouble setting up code that will work. My code and the results are pasted below: > jo<-odbcConnectExcel("i:\\all\\sorkinjohn\\stats\\silvermannatalie\\NEMOcombined06-24-0