[R] Error in sqlCopy in RODBC

Dieter Menne dieter.menne at menne-biomed.de
Wed Nov 26 10:04:33 CET 2008

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
and append=TRUE when things like this happens. The following works for me

channel = odbcConnectAccess("db.mdb")
sqlCopy(channel,"Select * from tab","newtab",destchannel=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.

More information about the R-help mailing list