[R] RODBC connection to locked Excel2010 files

Hi, I am trying to connect to an Excel2010 file while another user is entering data. (Obviously it would be better to set up a SQL database, but this is not an option at this point.). Typically we are not working on the same sheets. However, if possible I like to read the most current excel file in

[R] RODBC connection to locked Excel2010 files

Hi, I am trying to connect to an Excel2010 file while another user is entering data. (Obviously it would be better to set up a SQL database, but this is not an option at this point.). Typically we are not working on the same sheets. However, if possible I like to read the most current excel file in

[R] Linear Regression with Linear Equality Constraint

Please advice on the package I should use to run a linear regression model (weighted least squared) with linear equality constraint. I initially tried "constrOptim" but it turned out that it only supported inequality linear constraint. Thank you very much in advance. Cheers, Jon -- View this m