I have just got an idea which is using RExcel and coding with Excel VBA may cope with it, its work!!!
Ryusuke From: urishim...@optiver.com To: ryusukeke...@hotmail.com Date: Mon, 15 Feb 2010 08:31:49 +0100 Subject: RE: RE:Creating a new Access database with R No idea, sorry. Haven$B!G(Bt checked it since. You might want to look at simply creating a new file titled $B!F(Bjustanothername.mdb$B!G(B and see if it works (probably not) Sorry I can$B!G(Bt be more helpful, which is why I keep this off the list$B!D(B Uri From: Ryusuke Kenji [mailto:ryusukeke...@hotmail.com] Sent: Thursday 11 February 2010 16:51 To: Uri Shimron; r-help@r-project.org Subject: RE:Creating a new Access database with R I am facing the same problem as well, I would like to code with following concept but wondering how to cope it. if (*mdb file exist) { add new row/col } else { add new *mdb file } ---------------------------------------------------------------------------------------------- From: Uri Shimron <UriShimron_at_optiver.com> Date: Thu 21 Sep 2006 - 13:27:35 GMT First of all, since this is my first posting, I would like to thank anybody who [[elided Hotmail spam]] My question is: how do I create a new Access database with R? I need a channel before I can do anything, but if the mdb-file doesn't exist, I can't connect to it with odbcConnectAccess. I've looked at the RODBC.pdf on CRAN, searched the mailing-lists, and looked at test.R file in the package. But probably I've overlooked something. It is of course possible to keep a clean new mdb-file somewhere and then copy it to the required directory with: shell("copy EmptyDB.mdb NewLocation.mdb") But that isn't very elegant... Thanks in advance, Uri Shimron USB$B%a%b%jBe$o$j$K$*;H$$$/$...@$5$$!#l5na$g;H$($k(B25GB$B!#(B SkyDrive$B$r:#$9$0BN83(B *************************************************************************** This email and any files transmitted with it are confide...{{dropped:23}} ______________________________________________ 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.
