
I have just got an idea which is using RExcel and coding with Excel VBA may cope with it, its work!!!

Ryusuke

From: UriShimron@Optiver.com
To: ryusukekenji@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:ryusukekenji@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}}

