similar to: Access Data Base Reading on Linux Platform

Hi, I have been trying to get the sub function to work but can't for the life of me figure it out. I tried looking at ?sub but I think there is something that I am just not understanding. Example failed attempts > sub("\\","/","G:\Compensation Audits_Reports\Step Audit\Steps off Step.accdb") Error: '\C' is an unrecognized escape in character string

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

I am trying to use some ms access databases in R (version 1.9.1 or 2.0 on a Debian system). In searching the net for promising software to do this, I found mdbtools. Mdbtools claims the ability to convert schemas and tables in MS Access to MySQL and other databases. http://mdbtools.sourceforge.net/ I'm wondering if anyone in the R community has tried using this software to use

Hi again, I have played a little more with mdbtools and R. I downloaded the latest version of mdbtools from sourceforge (version 0.6pre1). Quickly scanning the mailing list suggests that ODBC seems to work with PHP but I have not been able to get it to work with R. I can make a connection to the database and when I do a query I get back the names of the rows but not the data. I must admit I have

HI, R Users, I met the following problem: I was trying to import data of one table in .accdb database into my ODBC database for being imported into R. The table contains 1021965 records. I always got the following error msg even I change the drive: The query can not be completed. Either the size of the query result is larger than the maximum size of a database(2GB), or there is not enough

Hi all, I am very new to R and I'm trying to import data from Microsoft Access. So far, I've managed to do so successfully using the following code: testdb <- file.path("c:\Databse.accdb") channel2 <- odbcConnectAccess2007(testdb) data.table <- sqlFetch(channel2,"data") This successfully imports a table(?) called "data.table". But when I try to

Morning everyone, I was hoping to use mdbtools to extract data from some Access databases overnight. I have yum installed the tools from Dag and also downloaded and (eventually!) compiled the latest release from the mdbtools web site, but I either get 'buffer overflow' errors or no output from most of the tools. I have been trying to cvs checkout the latest development version but

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

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-, ->

Hi Greetings to all Is my first post in this forum sorry for my english Many compliment to all developers for great work in Wine Profili2 is the most famous Windows software for designe airfoil profile for RC airplane models. Some times ago I have installed it in ubuntu 10.10 by Wine(1.3.5) with success This software use an mdb file First I have installed Profili download in this web site

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

Hi, Is there is anyway to Open Microsoft .mdb files in open office on Centos 5.3 ? Thanks linux

I have a geodatabase and would like to import it into GRASS, but it is in .mbf. I use mac and linux, and don't have access to access on the machines that I normally use. I do have access to access at school, but I would like to find a way around this if possible. Any thoughts, comments, or suggestions would be welcome. thanks, -- Stephen Sefick Let's not spend our time and resources

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

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

@Work requires me to manipulate the MS Access database (mdb) file located on an XP box that is an integral part of a third party application that is central to the business. Does anyone have experience doing so? I have used odbtp in the recent past but it is extremely difficult to set up on the linux box as I learned when I recently upgraded from CentOS 4.x to 5.x. Is there another way to get

I need to get read only access to a MDB database accessed from a Linux box using samba, anyone had any luck with this and know how to set it up? Please resist from posting your reasons why and MDB should not be used, I am the converted so stop preaching. The MDB is there to stay and I have to read to it. thanks -- Posted via http://www.ruby-forum.com/.

Hello I have problem with a access application, when I try to start the application then I must wait 5 minutes ago before he started. I do this from a WinXp Workstation to a Linux Debian Etch and samba 3.0.24 installation. What can I do for better performance. best regards pat

Hi There, I get the following error from the code pasted below: Error in storage.mode(test) <- "logical" : object 'HGBmt12_Natl_Ave_or_Facility' not found library(RODBC) library(car) setwd("c://temp//cms") a07.connect <- odbcConnectAccess2007("DFC.accdb") sqlTables(a07.connect) ##provides list of tables## dataset <-