[R] as.data.frame question

From: ruser ruser <ruser1000_at_yahoo.com>
Date: Thu 06 Jul 2006 - 19:37:22 EST


  I'm using the RODBC library to read in an Excel file using the odbcConnectExcel function. I can read the Excel data prefectly, however all my character variables get converted to factors when using   my.data <- as.data.frame(sqlFetch(channel, "Sheet1"))    

  I've tried using
  my.data <- as.data.frame(I(sqlFetch(channel, "Sheet1")))    

  but this creates just one column of data. Is there an efficient way to read in the character variables from my Excel data as characters rather than converting them to factors.    

  Any help is much appreciated.    



        [[alternative HTML version deleted]]

R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Fri Jul 07 02:53:07 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Fri 07 Jul 2006 - 04:15:25 EST.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.