Skip to content
Back to formatted view

Raw Message

Message-ID: <20010112125707.A2149@camille.indigoindustrial.co.nz>
Date: 2001-01-11T23:57:07Z
From: Jason Turner
Subject: read data into R with some constraints (Just out of curiosity)
In-Reply-To: <NEBBJKDJHEFCOOLFFAKKCEGECAAA.cyg@sympatico.ca>; from cyg@sympatico.ca on Thu, Jan 11, 2001 at 04:16:06PM -0500

> Assuming the answer is Yes. I would then ask if RODBC could also be used to
> do the same for a file residing on a Linux (Ext2fs) drive or any other file
> system for that matter?

Not an arbitrary filesystem, but if it's on a Linux box, and
it's really a big file, you might want to:

1) export the file to the Windows box via Samba.
2) apply the Windows ODBC text driver.
3) use RODBC to read the file.

Far too involved for a file this size, unless this is part
of a dynamic data / updating regularly problem.  In which case,
I'd suggest using a real database (Oracle, PgSQL, etc) and an
ODBC driver.

I say again: the above steps are really too convoluted for
everyday use, particularly if you don't have Samba set up 
already.  

Cheers,

Jason
-- 
Indigo Industrial Controls Ltd.
64-21-343-545
jasont at indigoindustrial.co.nz
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._