[R] Help: sqlSave Error
bruclee
brouce33 at gmail.com
Thu Nov 10 06:28:01 CET 2011
- Previous message: [R] Error in Summary.factor(c(1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 4L, : max not meaningful for factors
- Next message: [R] Help: sqlSave Error
- Messages sorted by:
[ date ]
[ thread ]
[ subject ]
[ author ]
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.futuresHighVol", append = TRUE, :
42S01 2714 [Microsoft][ODBC SQL Server Driver][SQL Server]
'futuresHighVol' already exist
[RODBC] ERROR: Could not SQLExecDirect 'CREATE TABLE
jrgchis.dbo.futuresHighVol ("TradeTime" varchar(255), "vol" float)'
Please Help!!!
--
View this message in context: http://r.789695.n4.nabble.com/Help-sqlSave-Error-tp4022523p4022523.html
Sent from the R help mailing list archive at Nabble.com.
- Previous message: [R] Error in Summary.factor(c(1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 4L, : max not meaningful for factors
- Next message: [R] Help: sqlSave Error
- Messages sorted by:
[ date ]
[ thread ]
[ subject ]
[ author ]
More information about the R-help
mailing list