Hello, Let's say that I have a data frame of n numbers I want to transfer into a Excel spreadsheet. I have opened the conection to the file using ODBC, and I can query the content of these n cells without problem. However, how do I transfer my new values to these cells? I.e., overwite them.
Should I use sqlSave() or sqlUpdate()? Using the update I get the error: "cannot update ‘data_001’ without unique column" sqlUpdate(connection_name, my_new_data_frame, "name_of_the_range_in_excel") Let's say that the range in Excel is in E10:E20. (if it matters) BR, Jay ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
