library(RODBC);
mdbConnect <- odbcConnectAccess("C:\\db.mdb");
data <- sqlFetch(mdbConnect, "tblData");
odbcClose(mdbConnect);
On 5/31/07, livia <[EMAIL PROTECTED]> wrote:
>
>
> Hi, I want to import some data from Access and I am using the following
> codes:
>
> testdb <- file.path("c/../db1")
> c
hursday, May 31, 2007 9:55 AM
> To: r-help@stat.math.ethz.ch
> Subject: [R] Import data from Access
>
>
> Hi, I want to import some data from Access and I am using the
> following
> codes:
>
> testdb <- file.path("c/../db1")
> channel <- odbc
Hi, I want to import some data from Access and I am using the following
codes:
testdb <- file.path("c/../db1")
channel <- odbcConnect("testdb")
sqlFetch(channel,"tbl",colnames = TRUE, rownames = FALSE)
It comes out the error message:
1: [RODBC] ERROR: state IM002, code 0, message [Microsoft][OD