[R] Re: Importing Excel .xls into R

Douglas Bates bates at stat.wisc.edu
Wed Dec 6 19:17:51 CET 2000


Alexandre Fayolle <Alexandre.Fayolle at logilab.fr> writes:

> On Wed, 6 Dec 2000, Richard A. Bilonick wrote:
> 
> > I don't believe there is any direct way of doing this. 
> 
> Isn't is possible to access an Excell document via ODBC ?

I know you can go the other way and import a table from an ODBC
connection into an Excel spreadsheet.  I did that recently.  

For this kind of exchange Excel is the client on the ODBC connection.
I would be surprised if one were able to transfer data the other way
by making Excel function as an ODBC server. Excel doesn't seem to have
a way of enforcing consistency in the contents of cells in a column
and consistency in columns is important for many other systems that
can use ODBC connections.  In some ways consistent storage and
interpretation for all the elements of a column is the defining
feature of a relational database table.

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._



More information about the R-help mailing list