Skip to content
Prev 515 / 1559 Next

Problems with sqlSave

Hello,
I am trying to load data into SQL Server as follows (example
simplified for discussion purposes). The returned error complains of a
non existent table, which I can nevertheless "see":
character(0)
TABLE_CAT TABLE_SCHEM             TABLE_NAME   TABLE_TYPE REMARKS
.................
19   MktRisk         dbo               sysusers SYSTEM TABLE    <NA>
20   MktRisk         dbo                Arrests        TABLE    <NA>
..................
Error in sqlSave(channel, dat = USArrests, tablename = Arrests,
rownames = "state",  :   object "Arrests" not found

in the real case (more complex and hard to show here), I get this error:
Error in sqlSave(channel, dat = the.bridge.df, tablename = someTable,
:   unable to append to table 'US15Aug2008BridgeTable'

As far as I can tell, the tables I create are of the appropriate kind
- any ideas what might be the problem?

Thank you,

Grey