[R] Trouble with Excel table connection

From: Steve Sherman <ssherman_at_cemml.colostate.edu>
Date: Fri 01 Jul 2005 - 04:46:12 EST


I've been using odbcConnectExcel to connect to a spreadsheet database containing a single worksheet. Unfortunately when I try to access the data R cannot see the table. When I run sqlTables it shows the worksheet as a SYSTEM TABLE instead of as a TABLE that I can access. I am fairly certain that I am do all of the same things I've done in the past when it worked just fine. What might I be doing wrong?

btw: it works just fine with MS Access, but I'd prefer to work directly from my Excel spreadsheets.

Thanks in advance

R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Fri Jul 01 04:50:36 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:33:08 EST