similar to: Error cargar datos ACCESS

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") :

Buenas: A ver si te puede servir: 1.- Creo que ROBDC sólo corre en la versión de 32-bits, no en la de 64-bits. Para ello: 1.1 En R-Studio -> Tools -> Global Options -> General -> Change -> 1.2 Elegir version de 32-bits 1.3.a) Para que se produzca el cambio -> seleccionar la versión de 32-bits que elijas, -> aceptar ?botón OK-, ->

Ya he visto como hacerlo: conexion<-odbcConnect("rx") Pero pense que podria elegir luego la bd que yo quisiera. Entiendo que de esta manera la base de datos siempre se tiene que llamar igual y estar en el mismo sitio, si no quiero andar modificando de nuevo la conexion con Windows. ¿Verdad? Gracias Jesús ________________________________ De: Jesús Para Fernández

Buenas, Estoy usando R para conectarlo con ACCESS pero me da error: > conexion<-odbcConnect("ProductionReport.mdb") Warning messages: 1: In RODBC::odbcDriverConnect("DSN=ProductionReport.mdb") : [RODBC] ERROR: state IM002, code 0, message [Microsoft][Administrador de controladores ODBC] No se encuentra el nombre del origen de datos y no se especificó ningún

una pregunta aun no comprendo totalmente el uso del signo $, me podrian decir donde encuentro su significado (si, si ya se que significa dinero y eso.........) desde el punto de vista de R gracias fabian huerta Yahoo! Cocina Encontra las mejores recetas con Yahoo! Cocina. http://ar.mujer.yahoo.com/cocina/ [[alternative HTML version deleted]]

Hi all, I want to use lattice v0.17-4 on R 2.6.2 to draw a panel of time series of zoo objects (zoo v1.5-0). Everything works until I try to separate panels a bit and show only the bottom axis line with tick marks on every panel (but not axis labels, which I want only on the bottom panels). I've tried several approachs, and the best I've got for showing only the bottom axis line and

HI: Is it possible to use the RODBC package within MS Access. I have been using from R but was just wondering if it could be used along with R(D)COM. Something like this: Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim myApp As StatConnector Set myApp = New StatConnector myApp.GetErrorText myApp.Init "R" myApp.EvaluateNoReturn "library(RODBC)" myApp.EvaluateNoReturn

Hi, Using the fast=F option, sqlSave saves without matching column names. It looks like a bug to me.......... Here's a simple (artificial) example. ----------------------------------------- Create a dataframe and save it to a database table "test" as follows: df <- data.frame(T=1, S=10) sqlSave(channel, df, "test", rownames=F) The table now looks like T S 1 10 If

Dear R Folks, I know that Enrique Bengoechea ( Credit Suisse ) had posted some code snippets for importing Bloomberg historical data into R. I found them to be very useful. Has anyone succeeded in getting the below items from Bloomberg to R? (a) historical economic release data, (b) tick/intra-day data (c) bulk data such as Index membership info, etc. If someone is willing to share their code

Dear all, I have some problems with importing data from an Access data base via RODBC to R. The data base contains several tables, which all are imported consecutively. One table has a column with column name "NO". If I run the code attached on the bottom of the mail I get no complain, but the column name (name of the respective vector of the data.frame) is "Expr1014" instead

Hi, This may be due to several reasons. That I can think about: 1) Ensure you close *all* possibly open workbooks: nBooks <- xl[["Workbooks"]]$Count(); for (i in seq_len(nBooks)) xl[["Workbooks"]]$item(i)$Close(SaveChanges=FALSE); 2) The excel application reference does not seem to be really released until the garbage collector runs. So this may help: xl$Quit();

Hi all, I'm trying to import Microsoft Access data into R. It looks like I'm supposed to use the ROBC package, and this works fine with old Access files (those with an .mdb extension). However, lovely Microsoft must constantly update their software. Modern Access files have an .ACCDB extension. I cannot seem to coerce R to import data from such a file. Any advice? I've been using

Hola, Tengo un conjunto de bases de datos de una encuesta industrial para diferentes años (1995-2014). Las bases de datos están en formato .mdb. A su vez, cada base de datos tiene 3 tablas con una variable "ID" común (la "llave") para vincular las tablas. Quiero realizar análisis estadísticos para analizar la evolución de ciertas variables. Quiero armar un dataframe que

Hi, I'm currently having some problem connect .mdb file into R. I've installed the RODBC packages and I do the code this way: channel <- odbcConnectAccess("C:/Users/Documents/XYZ") channel and it gave me this : RODBC Connection 3 Details: case=nochange DBQ=C:\USers\JieYi\Documents\NYP\IPP\GCR Driver={Microsoft Access Driver (*.mdb)} DriverId=25 FIL=MS Access

Tudor Bodea asked: >In this context, I try to get all the records for which market is atl-bos, >competitor is delta and dd is 2007-11-20 (first record above). To do this I used >># channel <- odbcConnectAccess("test.mdb") >>res <- sqlQuery(channel, "select * from test_table where market = 'atl-bos' >>and competitor = 'delta' and dd =

Hello, I would like to call a function that can take infinite time to be executed in some circumstances (which can not be easily detected). So, I would like that once the function is being executed for more than two seconds it is stopped. I have found documentation for timers but i did not found how to "kill" a function. Moreover, I would like not to change the function code (it should

Hi, I'm trying to get data from a MS SqlServer database into R, using the RODBC package. The problem I've found is that numeric data from my sql queries is returned with only two decimal digits. After searching the docs, I think the problem comes from my sql numeric data having "float" type instead of "double", as I found the following: "Where possible

Hola Amigos: Gracias por todas las respuestas sobre como filtrar datos en un data frame. Ahora tengo un nuevo problema, necesito instalar R 2.15 manualmente, pero no puedo hacerlo desde un repositorio. Alguna solución??????????' Un Saludos, Leonardo ------------ próxima parte ------------ An embedded and charset-unspecified text was scrubbed... Name: no disponible URL:

Dear all, I'm trying to connect to an MSAccess database (ArcGIS personal geodatabase). I keep getting an error about the channel when using sqlQuery(). However, sqlTables() does not complain about the channel and lists all tables in the database. If I try sqlFetch(), then R crashes. I'm happy to hear suggestions on how to solve this. Best regards, Thierry > MDB <-

De todas formas prueba a realizar la conexión de forma manual desde RStudio. Las últimas versiones (o al menos la Preview) incluyen una pestaña "Connections" con la que a través de un Wizard puedes configurar conexiones, entre ellas a ODBC y una de las opciones es "MS Access". Saludos, Carlos Ortega www.qualityexcellence.es El 31 de agosto de 2017, 12:11, Francisco Rodríguez