dbWriteTable unable to append/overwrite data to Access

[Ullix-xl]

Issue Description and Expected Result

issues:

library(odbc)
library(DBI)
library(tidyverse)

con <- dbConnect(odbc(),'testdb')
dbWriteTable(con,'mtcars',mtcars,overwrite = T) # doesn't work
dbWriteTable(con,'mtcars',mtcars[1,],overwrite = T)  # work

-->

Session Info

Error in result_insert_dataframe(rs@ptr, values, batch_rows) : nanodbc/nanodbc.cpp:1649: HYC00: [Microsoft][ODBC Microsoft Access Driver]可选的功?
#> output

[Ullix-xl]

Error in result_insert_dataframe(rs@ptr, values, batch_rows) : nanodbc/nanodbc.cpp:1649: HYC00: [Microsoft][ODBC Microsoft Access Driver]可选的功?

[erikvona]

Access doesn't support multi-row inserts. Use dbWriteTable(con,'mtcars',mtcars,overwrite = T, batch_rows = 1) to perform row-by-row inserts.

This is not a bug in odbc, but rather a limitation of MS Access.