
I am reading dates in Excel2007 into R.

Here are the functions I used:

library(RODBC)
channel<-odbcConnectExcel2007("myfile.xlsx")
tmp<-sqlFetch(channel,"1",as.is=T)


The dates in myfile.xlsx are all in this format: mm/dd/yyyy. But when I read it to R, some columns look like "yyyy-mm-dd 00:00:00", some columns look like "yyyy-mm-dd", and some columns are numbers. I do not know how I can control this.

 

Any help? Thanks!

 
 		 	   		  
_________________________________________________________________
Hotmail is redefining busy with tools for the New Busy. Get more from your inbox.

N:WL:en-US:WM_HMP:042010_2
	[[alternative HTML version deleted]]

