摘要:
# set work directorysetwd("w:/r")# load odbc librarylibrary(RODBC)# create an DSN and use it# myOdbc=odbcConnect("DSN")orcl=odbcConnect("orcl")# get data set# myDataset=sqlFetch(myOdbc,"TableName")my_data=sqlFetch(orcl,"DIM_RG")# get columns' nam 阅读全文