Try
library(RODBC)
Channel1 <- odbcConnectExcel2007("MyFile.xls", readOnly = TRUE)
Channel1
RODBC Connection 1
Details:
case=nochange
DBQ=g:\1\MyFile.xls
DefaultDir=g:\1
Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}
DriverId=1046
MaxBufferSize=2048
PageTimeout=5
On Tue, 11 Jun 2013 02:19:14 +0545
Christofer Bogaso wrote:
Any real answer would be contingent on a reader being provided a
reproducible example. Since you don't provide that, there's not a lot
of point to an answer. However, to tilt at a windmill, depending on the
size and complexity of your da
> -Original Message-
> From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org]
> On Behalf Of Jeff Newmiller
> Sent: Monday, June 10, 2013 9:45 PM
> To: Christofer Bogaso; r-help
> Subject: Re: [R] Fwd: Problem with ODBC connection
>
> Given t
Given the resounding silence, I would venture to guess that no-one here is
interested in troubleshooting ODBC connections to Excel. The problem is most
likely in the ODBC driver for Excel (not in R or RODBC), and Excel is NOT a
database (so any data format problem is unlikely to be detected).
--
Any response please? Was my question not clear to the list? Please let me
know.
Thanks and regards,
-- Forwarded message --
From: Christofer Bogaso
Date: Sat, Jun 8, 2013 at 9:39 PM
Subject: Re: Problem with ODBC connection
To: r-help
Hello All,
My previous post remains unans
5 matches
Mail list logo
