
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]]

