subject:"\[R\] Import data from Access"

[R] Import data from Access

2007-05-31 Thread livia

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

Re: [R] Import data from Access

2007-05-31 Thread Greg Snow

, 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 - odbcConnect(testdb) sqlFetch(channel,tbl,colnames = TRUE, rownames = FALSE) It comes

Re: [R] Import data from Access

2007-05-31 Thread Wensui Liu

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) channel -