[R] RODBC and Excel 2010 xlsx

[Prof Brian Ripley]

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 a

It'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