search for: mdbtool

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 o...

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 c...

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 MS-Access databases in R with a Linux system. If so, Were you successful?...

...ry' with the same output every time. I've compacted and repaired the database. I've created other mdb's, with the same result. When I connect to other DB's via RODBC, like MySQL, data is correct... What am I missing? Some output: -------------------------- ~# dpkg -l libmdb* mdbtools ii libmdbodbc 0.5.99.0.6pre1.0.20 MDB tools ODBC module ii libmdbtools 0.5.99.0.6pre1.0.20 mdbtools libraries ii mdbtools 0.5.99.0.6pre1.0.20 JET / MS Access database (MDB) tools -------------------------- ~# mdb-ver db.mdb JET4 -------------------------- R> odbcGetInfo(channel) DBMS_Name...

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

@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/.

Dear All, I am really far from a database expert (I do prefer flat files as long as that is reasonable), but I have to deal with an accdb database (Microsoft Access new format). It all stems from the fact that I run R almost exclusively on Debian platforms. I did a bit of googling http://r.789695.n4.nabble.com/How-to-load-data-from-accdb-into-R-td4656613.html

...hem inside of a for loop. This is the code I am using at the moment. library(Hmisc) # Read all tables in the Microsoft Access database blabla.mdb # perhaps better change to Locale in which the .mdb file was # generated to avoid that accented table column names are # getting lost.file first #mdbtools also has to be working Sys.setlocale('LC_ALL','C') Sys.setenv(PATH=paste(Sys.getenv('PATH'),'/sw/bin',sep=':')) d <- mdb.get('/Users/sefick/Desktop/FtBragg_GeoDataBase_AuburnUNV.mdb') f <- list() for(i in 1:length(d)){ a <- as.integer(d[[i]...