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 works/has worked on R, and made it such a beautiful open
source package!



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

        [[alternative HTML version deleted]]

______________________________________________
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.

Reply via email to