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:
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,
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
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:
4 matches
Mail list logo