Skip to content

problem with RODBC

1 message · Dave Evens

#
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