[R] -newbie | RODBC import query

[Jeff Newmiller]

Evan Cooch wrote:

[...]

> OK, so after a bit of reading, seems I need to use RODBC (I'm using 
> [R] 2.2.1 for Windows, at the moment). But, I can't seem to figure 
> out the basics. Suppose the file I need to 'work with' is 
> test.dbf  So, I try the following:
> 
>   library(RODBC);
>   import_dat <- odbcConnectDbase("c:\documents and 
> settings\egc\desktop\test.dbf")

[...]

> Suggestions? Apologies if this is easy, or (worse) and FAQ.

Without test data, I can't say much.  I don't use DBF very often
anymore, but I do use ODBC, and I always use ODBC Administrator
in the Control Panel to setup a DSN before using a data source.
Something to try, anyway.  I suspect you won't want to give any hints
to R about "Dbase" if you have to do that... it should be treated
as a generic data source.

-- 
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                       Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k