How to insert data to SQL Server table using R?

Question

I need help to write a simple data row to SQL server from R Language. (using RODBC or otherwise).

Answer 1

You can write all the data (all rows) using sqlSave(channel, data, rownames = FALSE) where channel <- odbcDriverConnect("Driver={SQL Server};Server=AAA;Uid=BBB;Pwd=CCC;"). This will create a table with a name data in your database.

You can then append your existing table by sqlQuery(channel, 'insert into table select * from data').