Problem with ODBC connection

Daniel Nordlund · 2013-06-11T05:32:59Z

> -----Original Message----- > From: r-help-bounces at r-project.org [mailto:r-help-bounces at 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 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

Daniel Nordlund

Mon, Jun 10, 2013 10:32 PM

I tried reading your workbook using your code, i.e.

library(RODBC)
MyData <- sqlFetch(odbcConnectExcel('mypath/Myfile.xls'), "aaaa")
head(MyData, 30)

and got an error message saying that odbcConnectExcel is only usable with 32-bit Windows and I have a 64-bit system, so I can't help you there.  But there are many other options in R for reading Excel workbooks.  I was able to read your data using the read.xls function from the gdata package.  I am not endorsing that package, it just happened to be the first package on my system that I tried.  

So if you can't read the data one way, try another.  You could install and load the sos package and runthe following function

findFn('xls')

and you will get all sorts of suggestions.


Hope this is helpful,

Dan

Daniel Nordlund
Bothell, WA USA

Problem with ODBC connection

Thread (7 messages)