Hello, 

I have an excel file that I load through RODBC. Some of my columns are
blank.  They are equity  time series and the stocks did not exist at the
earlier dates.  My problem is that the whole column becomes <NA> even though
there are numbers at later dates.

Here's my excel file 

http://www.tradebit.com/download.php/35699
<http://www.tradebit.com/download.php/35699> 

And here's the code I use:

library(RODBC)
chan <- odbcConnectExcel("C:/book54.xls") #load data
ts<- sqlFetch(chan, "Sheet1")
close(chan)
ts<-ts[-1,]

str(ts)
head(ts)
tail(ts)



Regards,

Pierre Lapointe
Assistant Market Strategist
National Bank Financial


*********************************************************************************** 
AVIS DE NON-RESPONSABILITE:\ Ce document transmis par courri...{{dropped}}


