similar to: Get data from Access 2010 database

Hi to all. I have a problem to connect to an Excel database using RODBC. Namely, I am using 64-bit R 2.14.0, under Windows 7 and I tried following: library(RODBC) > channel <- odbcConnectExcel("results.xlsx") Error in odbcConnectExcel("results.xlsx") : odbcConnectExcel is only usable with 32-bit Windows # ok this is clear why it doesn't work > channel

Hello Folks, I do hope this is the correct place to post (and not in R-SIG-DB). I have spent the better part of a day searching for an answer to this question, and have yet to resolve it. I am trying to query an .accdb Access database (with 32-bit Office 2007 currently residing on the machine) with 64-bit R via RODBC. There seem to be some conflicting accounts as to whether or not this is

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

Apologies, but after a fair amount of digging, I still only have a foggy understanding of the cause of this problem, due to my own ignorance. I hope to use RODBC package to connect to an Access DB when running 64 bit Win7 (R version 2.11.1, 64 bit). I have successfully done this before on a winXP machine. Currently I am unable to establish a connection using odbcConnect("") (I am

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

Hello Everyone,   I'm still quite new to R and am having trouble reading SQL Server Tables using RODBC. I've looked though the RODBC documentation as well as material I found online and in the book "Data Manipulation with R," but I just can't quite seem to get things to work.   Right now, I have code that looks something like:   channel <- odbcDriverConnect

Dear All, I want to connnect R with oracle. I am using RODBC package for this connection. Following is my code to connect library(RODBC) channel <- odbcConnect("Vikrant") I am getting following error. 1: In odbcDriverConnect("DSN=Vikrant") : [RODBC] ERROR: state NA000, code 12288, message [Microsoft][ODBC driver for Oracle][Oracle]ORA-12514: TNS:listener does not

Hi, I'm trying to use RODBC without having to set up a DSN, using hte direct connection string in odbcDriverConnect. My connection attempt looks something like: > odbcDriverConnect(connection = "SERVER=localhost;DRIVER={/usr/lib/odbc/libmyodbc.so};DATABASE=myDB;UID=reader;PASSWORD=insecure;") And this returns the message: Warning messages: 1: In odbcDriverConnect(connection =

Hi there, I have seen this post. https://stat.ethz.ch/pipermail/r-help/2007-June/133606.html have odbc installed in my machine. Now I have the following message: channel2 <- odbcDriverConnect("test.mdb")Warning messages:1: In odbcDriverConnect("test.mdb") : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no

Hello, I'm using R 2.2.0 on a Mac and attempting to use the RODBC package to connect to a PostgreSQL server on the local network. I can't tell whether my problem is in R, or in ODBC setup. I got drivers from OpenLink, created a dsn and tested it using the iODBC application. then I load the RODBC package, use this code and get the following error. I tried with both the

Hi, useR- I am connecting to Oracle database using RODBC, but keep getting this error message: > library(RODBC) > channel <- odbcConnect(dsn="abc", uid="abc", pwd="abc", case='oracle') Warning in odbcDriverConnect(st, ...) : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default

I think I figured this out. I should not have put the Driver name in braces. Changing it from {MySQL} to MySQL seems to work. -----Original Message----- From: Marcus, Jeffrey Sent: Tuesday, January 12, 2010 6:09 PM To: 'r-help at r-project.org' Subject: Problems connecting with MySQL using odbcDriverConnect (RODBC package) on Linux I am sure I'm doing something wrong here but not

I am trying to connect sybase sql databast from R using RODBC pkg and getting the following error ( i chnaged names to my*** but when I actually execute it, I put down names explicitly not calling some character strings) > channel = odbcConnect(dsn='mydsn',uid='myid',pwd='mypasswd') Warning messages: 1: [RODBC] ERROR: state IM002, code 0, message [iODBC][Driver

Hola a todos, estoy intentendo cargar unos datos contenidos en una tabla de ACCESS, por lo que ejecuto los siguientes comandos dir<-"C:/Users/D/Desktop/" library(RODBC) cn<-odbcConnectAccess(paste(dir1,"datos.mdb",sep="")) pero me da el siguiente error Warning messages: 1: In odbcDriverConnect(con, ...) : [RODBC] ERROR: state IM002, code 0, message

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

Hi List, just to know if the issue is only a problem of mine or if it is a general issue due to the new MS Office pack. I'm using R 2.11.1 32 bits in a Windows 7 x64 with the MS office 2010 x64 installed. I can import .xls files normally (the same way I did with my Excel 2007 32 bits). But the function odbcConnectExcel2007 isn't able to import .xlsx files now that I have the new version of

I have probably an old question. I have R.3.0.1 installed in 64 bit windows 7. The odbcConnectExcel in RODBC library does not work. Tried odbcConnectExcel2007 still does not work. Any ideas. Thanks Melissa<-sqlFetch(odbcConnectExcel2007("F:\\Cotton2012\\validation.xlsx"),sqtable = "Sheet3", + na.strings = "NA", as.is = TRUE) Error in

Hello, I want to try to connect R to PostgreSQL. I have found that there are three ways: DBI or RODBC or RPostgreSQL. I tried around with DBI and RODBC but didn't get it running. In both cases I'm not clear about how to set the driver/data source. I get this error: x > channel <- odbcConnect("rtest", uid="oliver") x Warning messages: x 1: In

Hi All, I'm using R 2.11.1 on 64 bit windows XP. The little function I wrote below I use often to import the first 1001 lines in an excel sheet to R. This works fine on the 32 bit version of R but fails on the 64 bit [both on the same machine, using the same function, importing the same .xls file]. The message from 64 bit R is: Error in sqlTables(channel1) : first argument is not an