Dear Alberto,
please note that special characters (eg a space character) in the Excel
sheet names mess up the simple way of querying provided by sqlFetch.
If you have a regular case of all sheets like Sheet1:
plan1 - sqlFetch(channel,Sheet1) # should work
But if you have Sheet 1 (
-
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
Dear Alberto,
channel - odbcConnectExcel(test.xls)
name1 - tables[1, TABLE_NAME] # the name1 is Sheet1$
it must be:
name1 - Sheet1
plan1 - sqlFetch(channel, name1) is ok
or
plan1 - sqlFetch(channel, Sheet1)
Regards,
Felipe
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL