# first row contains variable names
# we will read in workSheet mysheet

library(RODBC)
channel <- odbcConnectExcel("c:/myexel.xls")
mydata <- sqlFetch(channel, "mysheet")
odbcClose(channel)

http://www.statmethods.net/input/importingdata.html

connecting to .xls files

R