Re: [R] Help: sqlSave Error

2011-11-10 Thread Jeff Newmiller
The error seems clear enough to me... sqlSave is trying to create the table but it already exists. Some possible directions you could take: 1) Do your work on a particular instance of the table within a single transaction and rollback at the end. 2) Delete the table before you run sqlSave. 3) E

[R] Help: sqlSave Error

2011-11-09 Thread bruclee
I am using sqlSave to save my data into an existing table at MS SQL Server database. Previously my code ran smoothly but all of a sudden it stopped working. Here is my code: sqlSave(con, highVol, "dbo.futuresHighVol", append=TRUE, rownames=FALSE) Error: sqlSave(con, highVol, "jrgchis.dbo.futuresH