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 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 > stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! > R-project.org/posting-guide.html >