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]]
______________________________________________
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.
