R help - Jun 2005 - Trouble with Excel table connection

Hello,

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
Steve

The best 3 things you can do in this situation are:
1. don't use Excel.
2. never use Excel.
3. never ever use Excel again.

Spreadsheets are _not_ databases. In particular, Excel is a time bomb
- use it long enough and you'll get burned (perhaps without even
realizing it). See
http://www.burns-stat.com/pages/Tutor/spreadsheet_addiction.html for
some details.

hth,
b.

> -----Original Message-----
> From: Steve Sherman [mailto:ssherman at cemml.colostate.edu] 
> Sent: Thursday, June 30, 2005 2:46 PM
> To: r-help at stat.math.ethz.ch
> Subject: [R] Trouble with Excel table connection
> 
> 
> Hello,
> 
> 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
> Steve
> 
> ______________________________________________
> R-help at 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
>