I have a problem with RODBC statements that seems to be related to inserting
data into a table during an SQL batch (MS SQL Server). It started from a
stored procedure that didn't return data to R but I could boil it down to
the following simplified code snippets.
The first one does work:
sqlQuery(
Schalk,
This worked.
Thanks for the hint.
Walt
Schalk Heunis wrote:
Walt
I get the same message using R2.9.2 on Vista. Using
sqlFetch(con,'Sheet1') seems to however.
HTH
Schalk Heunis
On Thu, Sep 24, 2009 at 6:23 PM, Data Analytics Corp.
wrote:
Hi,
I'm attempting to use the RODBC
Walt
I get the same message using R2.9.2 on Vista. Using
sqlFetch(con,'Sheet1') seems to however.
HTH
Schalk Heunis
On Thu, Sep 24, 2009 at 6:23 PM, Data Analytics Corp.
wrote:
> Hi,
>
> I'm attempting to use the RODBC package on Windows Vista to import an excel
> spreadsheet. The spreadsh
r-help-boun...@r-
> project.org] On Behalf Of Data Analytics Corp.
> Sent: Thursday, September 24, 2009 10:23 AM
> To: r-help@r-project.org
> Subject: [R] RODBC problem
>
> Hi,
>
> I'm attempting to use the RODBC package on Windows Vista to import an
> excel spreadsheet.
Hi,
I'm attempting to use the RODBC package on Windows Vista to import an
excel spreadsheet. The spreadsheet has three worksheets the last of
which is blank. Following an example in Phil Spector's book (p. 34),
after creating a connection named con I did the following:
> con
RODBC Connecti
Good day, all.
I just upgraded to R 2.6.0. I re-installed my most-used packages including
RODBC to be sure I'm up-to-date. I have been working with a large insurance
claims dataset stored in a MS-Access database on a Windows machine. I have been
regularly exporting tables from R into it using s
his function generates in the background the concrete query. How can
> I view/log/... the concrete query?
>
> Regards,
>
> Bernhard
>
>> -Original Message-
>> From: DUPREZ Cédric [mailto:[EMAIL PROTECTED]
>> Sent: Friday, July 06, 2007 11:59 AM
&g
(list(out=out,outliers=outliers))
}
outlier(x)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of amor Gandhi
Sent: 26 September 2007 11:45
To: DUPREZ Cédric; Bernhard "Wellhöfer
Cc: [EMAIL PROTECTED]
Subject: Re: [R] RODBC problem
Hello,
I wrot
Hi.
It looks like the letter 'e' at the end of the table name is not latinic
'e'.
sqlFetch constructs the SQL query internally from the supplied table name:
ans <- sqlQuery(channel, paste("SELECT * FROM", dbname),
...)
What will be the answer for
sqlQuery(channel, paste("SELECT * FROM
TECTED] De la part de Bernhard
Wellhöfer
Envoyé : vendredi 6 juillet 2007 11:45
À : [EMAIL PROTECTED]
Objet : [R] RODBC problem
Hello,
I use a RODBC connection to a MySQL server on a Debian machine. The call to
odbcConnect() seems to be ok, but the result of the first
sqlFetch(channel,"t_
TECTED] De la part de Bernhard
Wellhöfer
Envoyé : vendredi 6 juillet 2007 11:45
À : [EMAIL PROTECTED]
Objet : [R] RODBC problem
Hello,
I use a RODBC connection to a MySQL server on a Debian machine. The call to
odbcConnect() seems to be ok, but the result of the first
sqlFetch(channel,"t_
11 matches
Mail list logo
