Skip to content

RODBC Package

3 messages · Stephan Freyberger, Brian Ripley, Don MacQueen

Stephan Freyberger
# 
Hello R-Help,

is there any way of using the RODBC Package on a Mac OS X 
System? If yes, what do I need to get it running. Concerning these 
issues, I am pretty unexperienced, so please state any step 
necessary. The actual problem is accessing data in Excel- files. 
(unfortunately no alternative way of entering the data). 
I already installed the Package, but it says the following:
Error: couldn't find function "odbcConnectExcel"

Thanks in Advance

Stephan Freyberger
Brian Ripley
#
On Fri, 11 Mar 2005, Stephan Freyberger wrote:

            

      
      
      
    

        
As the documentation says very clearly, odbcConnectExcel is only available 
on Windows.

Do you have an Excel ODBC driver?  If so, set up a DSN to point it at the 
file you want and call odbcConnect() with that DSN.

  
    

      
      
    

  


  


      

    

    
3 days later

    

      
      

        


  

        

      Don MacQueen
    

    

      
      #
    

  


  

      
The read.xls() function in the gdata package in the gregmisc bundle 
will import data from Excel spreadsheets on OS X.

I've used it with R 2.0.1 on Mac OS X 10.2.8, and the current version of Excel.

-Don

        
At 9:53 AM +0000 3/11/05, Stephan Freyberger wrote: