CODEWITHSUNDEEP
sqlsql-serverrrodbc
Saeedses
Saeedses

Reputation: 119

How to insert data to SQL Server table using R?

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

Upvotes: 4

Views: 10853

Answers (1)

danas.zuokas
danas.zuokas

Reputation: 4643

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

Upvotes: 9

Related Questions