sql - r XLconnect equivalent to sqlFetch -

i have old 32 bit snippet

xl <- odbcconnectexcel("c:/myfile.xls") data <- sqlfetch(xl, "flowers$") 

but have 64 bit machine , can't use odbcconnectexcel. have read should use xlconnect, how use sqlfetch xlconnect? i.e how rewrite second line of code?

try this

library(xlconnect)

xl <- loadworkbook("c:/myfile.xls")

data <- readworksheet(xl,"flower") #assumes worksheet name "flower"