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-04 13:16:31Z

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 4, 2016 at 13:16

answered Jan 4, 2016 at 12:59

danas.zuokas

4,6634 gold badges33 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Saeedses Over a year ago

Table is already there, I am looking for a Insert Into Table type thing.

danas.zuokas Over a year ago

Updated the answer. The reason I usually use this approach is speed - it is much quicker than inserting row by row.

Collectives™ on Stack Overflow

How to insert data to SQL Server table using R?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related