Re: [R] DBI::dbWriteTable syntax error apparently from quotes

I did not put the double quotes in the SQL statement. The SQL statement was created automatically by the routine dbWriteTable. The full code (minus the details of creating the DBIConnection object) would be like this, as in the man page for dbWriteTable library(DBI) library(odbc) conn <- [connect

Re: [R] DBI::dbWriteTable syntax error apparently from quotes

Double quotes are not legal SQL syntax. Use single quotes. -- Sent from my phone. Please excuse my brevity. On August 29, 2017 2:21:44 AM PDT, Eric Berger wrote: >I have been successfully using RODBC for a long time (years) to connect >to >MS SQL Server from R. >This week I wanted to try using o

[R] DBI::dbWriteTable syntax error apparently from quotes

I have been successfully using RODBC for a long time (years) to connect to MS SQL Server from R. This week I wanted to try using odbc but I am seeing some problems which may be related to how I set up my driver and/or connection. The dbWriteTable manual page gives as an example command: dbWriteTab