dbWriteTable() fails to write to existing table with non-default schema

[EthanTaft]

Reproducible Example:

#create a table in SSMS 
CREATE TABLE [guest].[MikeTestTable](
[a] [float] NULL,
[b] [float] NULL,
[c] [varchar](255) NULL)

#create a connection string to the database where the table was created
MSSQLConnectionString <- '
  driver={SQL Server};
  server=localhost;
  database=SAM;
  trustedConnection=true;
  '

#DBI Connection
library(DBI)
library(odbc)
con <- DBI::dbConnect(odbc::odbc(),
                      .connection_string = MSSQLConnectionString)

#small dataframe we want to insert/append to the table we created at the beginning
df <- data.frame(a = c(10, 20, 30),
                 b = c(20, 40, 60),
                 c = c("oneT", "twoT", "threeT"))

#try to write contents of df to the table
DBI::dbWriteTable(conn = con,
                  name = SQL('guest.MikeTestTable'),
                  value = df,
                  append = TRUE)

Error: <SQL> 'CREATE TABLE guest.MikeTestTable (
  "a" FLOAT,
  "b" FLOAT,
  "c" varchar(255)
)
'
  nanodbc/nanodbc.cpp:1587: 42S01: [Microsoft][ODBC SQL Server Driver][SQL Server]
There is already an object named 'MikeTestTable' in the database. 

Question
Why is dbWriteTable trying to create a new table when append = TRUE ?

[EthanTaft]

Sorry to write again. Have you guys looked into this issue yet? We are really in need of a solution right now but we know your time is busy. Cheers!

[EthanTaft]

Issue solved here

[JackStat]

@EthanTaft The link is dead sir. Can you update?

[EthanTaft]

@JackStat Thanks for pointing that out. This link should work.

[krlmlr]

Closing, see also #24.