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 can reproduce your error with my example file and fast=TRUE. You might try
fast=FALSE
and append=TRUE when things like this happens. The following works for me
library(RODBC)
channel = odbcConnectAccess("db.mdb")
sqlCopy(channel,"Select * from tab","newtab",destchannel=channel,
safer=TRUE,append=TRUE,rownames=FALSE,fast=FALSE)
odbcClose(channel)
--
View this message in context:
http://www.nabble.com/Error-in-sqlCopy-in-RODBC-tp20691929p20697101.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.