[R] RODBC and Excel 2010 xlsx

[Gabor Grothendieck]

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