Re: [R] reading in mdb and outputting to sql (GIS application)

2009-08-15 Thread Frank E Harrell Jr
stephen sefick wrote: tables=TRUE does return a list of tables with no error. The problem is that I can't get into the database because I am on a macintosh. I would send you the database, but it is for a military base and I don't believe that I am allowed. I'll see if I can't figure it out. T

Re: [R] reading in mdb and outputting to sql (GIS application)

2009-08-15 Thread stephen sefick
tables=TRUE does return a list of tables with no error. The problem is that I can't get into the database because I am on a macintosh. I would send you the database, but it is for a military base and I don't believe that I am allowed. I'll see if I can't figure it out. Thanks for all of the hel

Re: [R] reading in mdb and outputting to sql (GIS application)

2009-08-15 Thread Frank E Harrell Jr
stephen sefick wrote: 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 Sys.setenv(PATH=paste(Sys.getenv('PATH'),'/sw/b

Re: [R] reading in mdb and outputting to sql (GIS application)

2009-08-14 Thread milton ruser
Hi Stephen, I have read .mdb files using RODBC package. Try give a look on it. bests milton On Fri, Aug 14, 2009 at 7:55 PM, stephen sefick wrote: > > library(Hmisc) > > # Read all tables in the Microsoft Access database blabla.mdb > > # perhaps better change to Locale in which the .mdb f

Re: [R] reading in mdb and outputting to sql (GIS application)

2009-08-14 Thread stephen sefick
> 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 > Sys.setenv(PATH=paste(Sys.getenv('PATH'),'/sw/bin',sep=':')

Re: [R] reading in mdb and outputting to sql (GIS application)

2009-08-14 Thread stephen sefick
thank you all- I will report back when I have tried on my computer at home. On Fri, Aug 14, 2009 at 12:24 PM, Phil Spector wrote: > Stephen - >   You can modify your path on the fly with Sys.setenv: > > Sys.setenv(PATH=paste(Sys.getenv('PATH'),'/sw/bin',sep=':')) > > should make executables instal

Re: [R] reading in mdb and outputting to sql (GIS application)

2009-08-14 Thread Phil Spector
Stephen - You can modify your path on the fly with Sys.setenv: Sys.setenv(PATH=paste(Sys.getenv('PATH'),'/sw/bin',sep=':')) should make executables installed in /sw/bin available to R. - Phil Spector Statistical

Re: [R] reading in mdb and outputting to sql (GIS application)

2009-08-14 Thread Frank E Harrell Jr
You need a fundamental solution to your system problem but a quick fix is to provide a symbolic link to the executable from a place that is in your system path. Frank stephen sefick wrote: Frank, I have tried to use this package, but because I am using fink to install packages the mdbtools b

Re: [R] reading in mdb and outputting to sql (GIS application)

2009-08-14 Thread Prof Brian Ripley
The AT Access driver works reasonably well: it is described in the current RODBC manual. On Fri, 14 Aug 2009, Marc Schwartz wrote: On Aug 14, 2009, at 10:29 AM, stephen sefick wrote: I have a geodatabase and would like to import it into GRASS, but it is in .mbf. I use mac and linux, and don

Re: [R] reading in mdb and outputting to sql (GIS application)

2009-08-14 Thread stephen sefick
Frank, I have tried to use this package, but because I am using fink to install packages the mdbtools binary they are not accessible by the function from within R. I checked this by just trying to call it with the system function and R returned /bin/sh not found. I can access the binary from the

Re: [R] reading in mdb and outputting to sql (GIS application)

2009-08-14 Thread Frank E Harrell Jr
The R Hmisc package interfaces these tools - see its mdb.get function. Frank Marc Schwartz wrote: On Aug 14, 2009, at 10:29 AM, stephen sefick wrote: 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 m

Re: [R] reading in mdb and outputting to sql (GIS application)

2009-08-14 Thread Marc Schwartz
On Aug 14, 2009, at 10:29 AM, stephen sefick wrote: 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 aro