Re: [R] Error in sqlCopy in RODBC

2008-12-01 Thread BKMooney
The exact syntax I am running in R is as follows: query <- " select * from tblHistorical where MyDate between '2008-11-21' and '2008-11-25' ; " sqlCopy(RemoteChannel, query, "NewTable", destchannel=LocalChannel, safer=TRUE, append=TRUE, rownames=FALSE, fast=FALSE) Both RemoteChannel and LocalCh

Re: [R] Error in sqlCopy in RODBC

2008-11-27 Thread Dieter Menne
BKMooney wrote: > > I tried your suggestion... > > library(RODBC) > channel = odbcConnectAccess("db.mdb") > sqlCopy(channel,"Select * from tab","newtab",destchannel=channel, > safer=TRUE,append=TRUE,rownames=FALSE,fast=FALSE) > odbcClose(channel) > > however, I am still running into errors,

Re: [R] Error in sqlCopy in RODBC

2008-11-26 Thread BKMooney
I tried your suggestion... library(RODBC) channel = odbcConnectAccess("db.mdb") sqlCopy(channel,"Select * from tab","newtab",destchannel=channel, safer=TRUE,append=TRUE,rownames=FALSE,fast=FALSE) odbcClose(channel) however, I am still running into errors, both when appending to an existing tab

Re: [R] Error in sqlCopy in RODBC

2008-11-26 Thread Dieter Menne
BKMooney wrote: > > I am trying to copy portions of tables from one SQL database to another, > using sqlCopy in the RODBC package. > > ... > I am currently getting an error: > Error in sqlSave(destchannel, dataset, destination, verbose = verbose, : > table 'LocalTable' already exists > I