[R] -newbie | RODBC import query
Evan Cooch
evan.cooch at cornell.edu
Sat Apr 1 19:31:27 CEST 2006
At 12:14 PM 4/1/2006, Gabor Grothendieck 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")
>
>\ is the escape character so if you want a \ you must use \\ like this:
>
>odbcConnectionDbase("c:\\documents and settings\\egc\\desktop\\test.dbf")
>
>or do this:
>
>odbcConnectionDbase(file.choose())
Well, OK, but that doesn't make any apparent difference it in terms
of solving the problem I'm having. the odbcConnecDbase command is
working fine (i.e., its finding the test.dbf file), but after that, nada.
More information about the R-help
mailing list