Displaying 6 results from an estimated 6 matches for "mdbconnect".
Did you mean:
dbconnect
2012 Feb 24
1
looping over string of frames when importing with 'sqlFetch' from a Microsoft Access database
...ments (I came from stata)
I would very much appreciate if anyone on the list could help me solve this problem, as it is an issue of connecting to a database I can't really make a working example, please bear with me.
### not-working R code ###
##?first I establish a connection to my database
mdbConnect<-odbcConnectAccess("C:\\... \\database.mdb")
## then I read of all the table names
stringTables <- sqlTables(mdbConnect, tableType=c("TABLE"))$TABLE_NAME
## and then I meet the wall ...
for(i.Frame in stringTables) {
?? ?i.Frame <- sqlFetch(mdbConnect, i.Frame)
}
## t...
2010 Jul 19
1
Connecting to MS Access database
Hi All,
Can anyone please suggest me from where should I start to learn about 'how
to connect to access db' ?
How if someone has some written code and I can go over that to understand
and make necessary changes... any help would be highly appreciated,
--
Xin Ge.
[[alternative HTML version deleted]]
2006 Jun 23
3
R connectivity to database
Hello, does anyone know how I would go about getting R to connect to OpenOffice's Base program (OOo's version of MS Access) such that I can retrieve data from the database and perform calculations and data analysis? I'm totally new to R and Base and I've looked at some documentation, but found only examples for R connecting to PostgreSQL and MySQL, but nothing for OOo's Base
2012 Mar 28
1
Is it possible to de-select with sqlQuery from the RODBC library?
Dear R-list,
I'm queering a M$ Access database with the sqlQuery function from the RODBC library. As I cannot make a working example with a database here is an illustrative example,
library(RODBC)
mdbConnect<-odbcConnectAccess("S:/data/ ... /databse.mdb")
data <- sqlQuery(mdbConnect, "select id, DOB, V1, V2, ..., V1009, V1011, V1013 from someTable")
I want everything in the table (someTable), except 'V1010' and 'V1012,' but I can't figure out how to make a...
2007 May 31
2
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 out the error message:
1: [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver
Manager] Data source name not found and no default
2015 Apr 27
2
Como conectar R con una base de datos Access en Windows 64-bit (RODBC package)
Hola a tod en s,
Tengo un problema a la hora de conectar una base de datos (*.mdb) de Access
a RStudio utilizando windows 64-bit. Con el paquete RODBC utilizo el
siguiente script que devuelve el error que indico:
mdbConnect <- odbcConnectAccess("C:/Users/database.mdb")
Error in
odbcConnectAccess("C:/Users/Isa/FPI-AZTI/JUVENA/Databases/MEGASCOPE_JUVENA2014.mdb")
:
odbcConnectAccess is only usable with 32-bit Windows
He probado también con el siguiente, pero de nuevo sin éxito:
mdb <- odbc...