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