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).

danas.zuokas · Accepted Answer · 2016-01-04T13:16:31.143

9

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').

edited Jan 04 '16 at 13:16

answered Jan 04 '16 at 12:59

danas.zuokas

4,551
4
29
39

Table is already there, I am looking for a Insert Into Table type thing. – Saeedses Jan 04 '16 at 13:14
1

Updated the answer. The reason I usually use this approach is speed - it is much quicker than inserting row by row. – danas.zuokas Jan 04 '16 at 13:17

How to insert data to SQL Server table using R?

1 Answers1

Linked