Skip to content

Error appending data using RODBC, sqlSave()

2 messages · scoyoc, Thierry Onkelinx

Original
scoyoc
# 
I need to update tables in an MS Access database, but sqlSave(..., append =
TRUE) keeps returning errors. I've spent the better part of the last hour
on Google, but haven't found an adequate answer. Here's my code.

#+ Munge ----
Observations: 58
Variables: 7
$ PlotID           (fctr) C057, C085, C091, C128, C133, C233, C284, C311,
C312, C401, C418, ...
$ Re-sampleDate    (time) 2014-07-24, 2014-08-29, 2014-09-27, 2014-10-01,
2014-08-30, 2014-0...
$ Notes            (str) NA, NA, Something important about the plot visit...
$ SppRichStartTime (time) 13:09:00, 11:23:00, 13:54:00...
$ SppRichEndTime   (time) 13:21:00, 11:38:00, 14:15:00...
$ SppRichNotes     (fctr) NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA...
$ SppRichTotalTime (time) 00:12:00, 00:15:00, 00:21:00...
Observations: 52
Variables: 3
$ PlotID        (fctr) C021, C057, C085, C091, C128, C133, C233, C284,
C311, C312, C401, C41...
$ Re-sampleDate (time) 2014-08-29, 2014-07-24, 2014-08-29, 2014-09-27,
2014-10-01...
$ Notes         (fctr) NA, NA, NA, Something important about the plot
visit...
+   filter(!(PlotID %in% plots.sum$PlotID)) %>%
+   select(PlotID:Notes)
Observations: 7
Variables: 3
$ PlotID        (fctr) D098, D104, D105, D605, D607, D608, D649
$ Re-sampleDate (time) 2015-10-14, 2015-09-29, 2015-09-30, 2015-10-16,
2015-10-15...
$ Notes         (fctr) NA, NA, NA, NA, NA, NA, NA
Error in sqlSave(Summaries.DB, plots.write, "tblPlotsResampled", append =
TRUE) :
  unable to append to table ?tblPlotsResampled?

Thanks,

MVS
=====
Matthew Van Scoyoc
=====
Think SNOW!
1 day later
Thierry Onkelinx
# 
Dear Matthew,

Have you tried converting the factors into characters?

Best regards,

ir. Thierry Onkelinx
Instituut voor natuur- en bosonderzoek / Research Institute for Nature and
Forest
team Biometrie & Kwaliteitszorg / team Biometrics & Quality Assurance
Kliniekstraat 25
1070 Anderlecht
Belgium

To call in the statistician after the experiment is done may be no more
than asking him to perform a post-mortem examination: he may be able to say
what the experiment died of. ~ Sir Ronald Aylmer Fisher
The plural of anecdote is not data. ~ Roger Brinner
The combination of some data and an aching desire for an answer does not
ensure that a reasonable answer can be extracted from a given body of data.
~ John Tukey

2015-12-09 23:16 GMT+01:00 Matthew Van Scoyoc <scoyoc at gmail.com>: