[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:

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 On Thu,

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

2009-06-25 Thread Rodrigo Aluizio
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 setting up code that will work. My

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: