Hi List, just to know if the issue is only a problem of mine or if it is a
general issue due to the new MS Office pack. I'm using R 2.11.1 32 bits in a
Windows 7 x64 with the MS office 2010 x64 installed. I can import .xls files
normally (the same way I did with my Excel 2007 32 bits). But the function
odbcConnectExcel2007 isn't able to import .xlsx files now that I have the
new version of the Office package.
It gives me the following warning message, which make impossible the
importing process through sqlFetch:
Warning messages:
1: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) :
[RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver
Manager] Nome da fonte de dados não encontrado e nenhum driver padrão
especificado (Source name not found and no default driver specified)
2: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) :
ODBC connection failed
I'm obviously bypassing it converting my .xlsx files to .xls.
Well the question is simple. Is this an expected issue, like the one when
the xlsx format was released and it will be worked out, or I'm having and
specific problem at one of my system components (drivers)?
Thank you very much for the attention.
Rodrigo Aluizio
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
