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]]
On Tue, Jul 13, 2010 at 9:31 AM, Rodrigo Aluizio <r.aluizio at 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
On Tue, 13 Jul 2010, Rodrigo Aluizio 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 aIt's a Microsoft muddle, covered in the RODBC manual for the next release. Note that R-sig-db is the right list for questions about RODBC, not R-help. Simply, if you have MS Office 2007/2010 installed, you can only have its ODBC drivers of the same architecture installed. Nothing to do with RODBC nor R, and something MS omits to mention on the download page for the drivers. Also, the ODBC data sources manager for x64 Windows tells you only about 64-bit drivers and DSNs. There is a different manager for 32-bit, but it is rather hidden .... The simplest thing to do is to use 64-bit R. I found this out the other way round: I have 32-bit Office installed and could not install the 64-bit ODBC drivers. The pre-release of RODBC at http://www.stats.ox.ac.uk/pub/R/RODBC_1.3-2.tar.gz is only available as a source package, but you can unpack it and read the updated manual.> 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]] > >-- Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595