On Thu, 31 May 2007, Lucke, Joseph F wrote:
> As a newbie to RODBC (Windows XP), I find that the commands aren't
> working quite as expected.
> After
> Library(RODBC)
>
> I had planned to use the two-step process
>
> myConn = odbcConnectExcel("Dates.xls")
> sqlQuery(myConn,"SELECT ID, ADM_DATE, AD
As a newbie to RODBC (Windows XP), I find that the commands aren't
working quite as expected.
After
Library(RODBC)
I had planned to use the two-step process
myConn = odbcConnectExcel("Dates.xls")
sqlQuery(myConn,"SELECT ID, ADM_DATE, ADM_TIME FROM A") #A is the Excel
spreadsheet name
X = sqlGetRe
Thanks Brian and Sean,
Works well and solves another problem I had: changing
the same condition in a series of related but
different queries, by making only one change in a
variable that is then used in all the queries.
Mikkel
--- Sean Davis <[EMAIL PROTECTED]> wrote:
> I often use paste to bui
I often use paste to build up SQL queries into line-sized chunks, but
this is only a convenience and not required. It does improve
readability and maintainability, in my opinion.
Sean
On Sep 1, 2004, at 5:09 AM, Mikkel Grum wrote:
Dear R-helpers,
When I use sqlQuery in the package RODBC, I cann
Not true: you have to submit the query as one element of a character
vector, not the same thing at all. You *can* use paste() to assemble it.
On Wed, 1 Sep 2004, Mikkel Grum wrote:
> Dear R-helpers,
>
> When I use sqlQuery in the package RODBC, I cannot
> break the line, but have to write the e
Dear R-helpers,
When I use sqlQuery in the package RODBC, I cannot
break the line, but have to write the entire SQL Query
on the same line. Is this expected behaviour? It is
definitely workable, but makes the queries a slightly
difficult to read and edit.
I'm using R 1.9.1 and RODBC 1.0-4 on Win