I'm using sqlQuery() to import excel-data (.xlsx). Almost everthing works perfect. But a column which contains type numeric as well as character is read as numeric. characters are unfortunately transformed to NA. How can I read all columns as characters? I've allready tried 'as.is=TRUE'.
Thanks, juerg ________________________________ This e-mail (including any attachments) is confidential,...{{dropped:13}} ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.