On Tue, Jul 13, 2010 at 9:31 AM, Rodrigo Aluizio <r.alui...@gmail.com> wrote: > 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. >
Suspect its a driver issue but you might want to look over the variety of methods for reading in Excel spreadsheets here: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows&s=excel ______________________________________________ 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.