[R] problem with RODBC

From: Dave Evens <devens8765_at_yahoo.com>
Date: Thu 21 Apr 2005 - 00:20:20 EST

Dear all,

I'm reading data via the RODBC connection using odbcConnectExcel. I use sqlFetch(channel, "sheetx") to identify the correct tab. It appears to read the data without any problems. However, when I exact a portion of data - the row number specified is 1 less than in the actual excel file and it can't read any columns after the 94th column.

Can someone help me? TIA

Dave



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 Thu Apr 21 01:08:53 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:31:17 EST