Displaying 1 result from an estimated 1 matches for "acciones_col".
2011 Mar 31
0
Problems reading excel file with RODBC connect
Hello, I am trying to read an Excel file using RODBC connect (its attached)
using the following code:
Data<-odbcConnectExcel2007('acciones_col.xlsx',readOnly=T,)
datos<-sqlFetch(Data,'Bloomberg')
odbcClose(Data)
The file contains stock data downloaded from bloomberg, and it contains five
variables per stock (so every five columns there is an empty column) . As
the bloomberg output comes, in the first row there are the...