search for: mdbtools

Displaying 11 results from an estimated 11 matches for "mdbtools".

2004 Nov 02
2
A little more on R, mdbtools and Access databases
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...
2008 Jun 20
2
mdbtools on CentOS
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 cv...
2004 Nov 01
3
ms access --> mysql --> R in Linux
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?...
2008 Sep 24
0
Error results from MS Access via RODBC
...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 &...
2009 Nov 23
2
Microsoft .mdb files in Open office
Hi, Is there is anyway to Open Microsoft .mdb files in open office on Centos 5.3 ? Thanks linux
2009 Aug 14
1
reading in mdb and outputting to sql (GIS application)
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
2011 Dec 14
2
Using an MS Access database from CentOS release 5.7 (Final)
@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
2006 Sep 21
4
Access and MDB file from Linux
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/.
2017 Jul 31
1
Access Data Base Reading on Linux Platform
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
2009 Aug 16
0
large list from mdb.get - change labled atomic to double
...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]]...
2007 Jun 14
3
help me