Re: [R] 64 bit use of odbcConnectExcel

Still doesn't work, any ideas? Error in sqlTables(channel1) : first argument is not an open RODBC channel In addition: Warning messages: 1: In odbcDriverConnect(con, tabQuote = c("[", "]"), ...) : [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name n

Re: [R] 64 bit use of odbcConnectExcel

Try using odbcConnectExcel2007, instead of odbcConnectExcel. That has worked for me. Cheers, Mike. > Message: 60 > Date: Thu, 22 Jul 2010 09:14:23 -0700 (PDT) > From: "Jack T." > To: r-help@r-project.org > Subject: [R] 64 bit use of odbcConnectExcel > Message-

[R] 64 bit use of odbcConnectExcel

Hi All, I'm using R 2.11.1 on 64 bit windows XP. The little function I wrote below I use often to import the first 1001 lines in an excel sheet to R. This works fine on the 32 bit version of R but fails on the 64 bit [both on the same machine, using the same function, importing the same .xls f