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

