 
   
  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.
   
  Regards,
   
  Harry
   

 		
---------------------------------


	[[alternative HTML version deleted]]

