[R-sig-DB] Error appending data using RODBC, sqlSave()

[Matthew Van Scoyoc]

Hi Thierry,

Thanks for the suggestions. That worked. I needed to change factors and
times to character, then RODBC appended the data quite smoothly.

Cheers,

MVS
=====
Matthew Van Scoyoc
=====
Think SNOW!

On Fri, Dec 11, 2015 at 5:14 AM, Thierry Onkelinx <thierry.onkelinx using inbo.be>
wrote:

> 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 using gmail.com>:
>
>> 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 ----
>> > # Call in resampled plots from CRC_Data.DB
>> > resample <- sqlFetch(CRC_Data.DB, "tblResampledPlots")
>> > glimpse(resample)
>> 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...
>> >
>> > # Call in resampled plots from Summaries.DB
>> > plots.sum = sqlFetch(Summaries.DB, "tblPlotsResampled")
>> > glimpse(plots.sum)
>> 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...
>> >
>> > # Select the new data
>> > plots.write = resample %>%
>> +   filter(!(PlotID %in% plots.sum$PlotID)) %>%
>> +   select(PlotID:Notes)
>> > glimpse(plots.write)
>> 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
>> >
>> > #+ AppendData ----
>> > sqlSave(Summaries.DB, plots.write, "tblPlotsResampled", append = TRUE)
>> Error in sqlSave(Summaries.DB, plots.write, "tblPlotsResampled", append =
>> TRUE) :
>>   unable to append to table ‘tblPlotsResampled’
>>
>> Thanks,
>>
>> MVS
>> =====
>> Matthew Van Scoyoc
>> =====
>> Think SNOW!
>>
>>         [[alternative HTML version deleted]]
>>
>> _______________________________________________
>> R-sig-DB mailing list -- R Special Interest Group
>> R-sig-DB using r-project.org
>> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>
>
>

	[[alternative HTML version deleted]]