plan1 - sqlFetch(channel, name1) is ok
or
plan1 - sqlFetch(channel, Sheet1)
Regards,
Felipe
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Alberto Monteiro
Sent: Tuesday, March 06, 2007 9:37 AM
To: r-help@stat.math.ethz.ch
Subject: [R] Package RODBC
-
From: Wolfgang Raffelsberger [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 07, 2007 4:50 AM
To: Mendiburu, Felipe (CIP)
Cc: Alberto Monteiro; r-help@stat.math.ethz.ch
Subject: Re: [R] Package RODBC
Dear Alberto,
please note that special characters (eg a space character) in the Excel
I have some questions about the RODBC package.
library(RODBC) # required for those who want to repeat these lines
1st, I noticed that the following sequence does not work:
channel - odbcConnextExcel(test.xls)
tables - sqlTables(channel)
name1 - tables[1, TABLE_NAME] # this should be
PROTECTED] Behalf Of Alberto Monteiro
Sent: Tuesday, March 06, 2007 9:37 AM
To: r-help@stat.math.ethz.ch
Subject: [R] Package RODBC
I have some questions about the RODBC package.
library(RODBC) # required for those who want to repeat these lines
1st, I noticed that the following sequence does