Displaying 1 result from an estimated 1 matches for "setting_id".
2011 Mar 03
1
sqlFetch (RODBC) question
...qlFetch would set text within a row of numbers to NA; but
if first 5 or 6 rows would be text then all numbers would be read in as NA.
con<-odbcConnectExcel("xample.xls") #the file is attached or at
http://psych.ut.ee/~nek/ajutine/xample.xls
sqlFetch(con, "TT$")
# ID_NO Setting_ID
#1 NA NA
#2 1220000 12203
# 3 1220001 12203
#etc
Whereas the same file saved as csv reads in correctly as:
read.csv("xample.csv")
# ID_NO Setting_ID
#1 b a
#2 1220000 12203
#3 1220001 12203
#4 1220002 12202
#5 1220003...