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]]
As a workaround, you can keep an empty mdb file on your filesystem. When you need a new database, you can copy and rename the empty file. -- View this message in context: http://n4.nabble.com/Re-Creating-a-new-Access-database-with-R-tp1477400p1477533.html Sent from the R help mailing list archive at Nabble.com.
Paul- wrote:> > As a workaround, you can keep an empty mdb file on your filesystem. When > you need a new database, you can copy and rename the empty file. > >Creating a new database is not part of (R)ODBC because there are too many differences between implementations. You you use some RDCOM method to do that, though. Dieter -- View this message in context: http://n4.nabble.com/Re-Creating-a-new-Access-database-with-R-tp1477400p1477613.html Sent from the R help mailing list archive at Nabble.com.
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}}