R help - Nov 2008 - Error in sqlCopy in RODBC

Hi All,

I am trying to copy portions of tables from one SQL database to another,
using sqlCopy in the RODBC package.

RemoteChannel = connection to remote database
LocalChannel = connection to local database
LocalTable = table in my local database to receive data from the remote
database

query <- select query in SQL

sqlCopy(RemoteChannel, query, "LocalTable", destchannel=LocalChannel,
safer=TRUE)

I am currently getting an error:
Error in sqlSave(destchannel, dataset, destination, verbose = verbose,  :
  table 'LocalTable' already exists

I need to append the data retreieved through the query, to the table
LocalTable.  It was my understanding that when safer=TRUE, it would append
the new data to an existing table, or create a new table otherwise.

This error seems to suggest otherwise.  Any ideas?

All your help is greatly appreciated!

	[[alternative HTML version deleted]]

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.