Now my Windows machine is back online again, I have been able to do some
work on this.
You can download the latest ODBC drivers from download.microsoft.com
(select Office as the product, search for ODBC and you will get to
AccessDatabaseEngine.exe). You don't need any version of Office install
"Earl F. Glynn" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I'll try the odbcDriverConnect and let you know.
Thanks. odbcDriverConnect worked fine for me, too, with new Excel 2007
formats:
library(RODBC)
channel <- odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.x
"Marc Schwartz" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> This might be a question along the lines of "is it plugged in?", but do
> you have the Office 2007 version of the ODBC drivers installed?
>
> If not, then your results would not be a surprise.
>
> If you do, then we shou
On Wed, 2007-10-17 at 20:53 +0200, kees wrote:
> For me, it works. That is to say, not the simple way, which gave the error:
> odbcConnectExcel("C:\\Users\\Kees\\Desktop\\Map1.xlsx")
>
> But it does when you ask the correct driver
> odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx,
For me, it works. That is to say, not the simple way, which gave the error:
odbcConnectExcel("C:\\Users\\Kees\\Desktop\\Map1.xlsx")
But it does when you ask the correct driver
odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm,
*.xlsb);DBQ=C:\\Users\\Kees\\Desktop\\Map1.xlsx
On Wed, 2007-10-17 at 11:53 -0500, Earl F. Glynn wrote:
> "Marc Schwartz" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > On Tue, 2007-10-16 at 14:38 +0100, Arnold Akem wrote:
> >> Hey Seniors,
> >>
> >> Really new to R, please has anyone imported a dataset from MS office
> >>
"Marc Schwartz" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Tue, 2007-10-16 at 14:38 +0100, Arnold Akem wrote:
>> Hey Seniors,
>>
>> Really new to R, please has anyone imported a dataset from MS office
>> excel 2007 into R yet? It seem to be giving me hard times which I did
Quoting Scionforbai <[EMAIL PROTECTED]>:
>> It would be dumb to ignore the fact that Excel is a very widespread
>> program, and therefore in the real world we are very likely to
>> encounter data formatted by Excel.
>
> Of course I know the widespreading of such programs. But the point is:
> how c
> It would be dumb to ignore the fact that Excel is a very widespread
> program, and therefore in the real world we are very likely to
> encounter data formatted by Excel.
Of course I know the widespreading of such programs. But the point is:
how can we start to change this in the real world? Peop
Quoting Scionforbai <[EMAIL PROTECTED]>:
> I just wonder: why should R and its community try to support such an
> awful program, with its protected formats and unmantained
> features/bugs?
> I mean, from both philosophical and technical point of view: R is free
> software and should rather try to
>
> The best way to read or write Excel files is with the RExcel package. The
Well, I'd argue, that often 'the best way' is to use the xlsReadWrite
package, but I am biased...
There are some precondition:
- you have to be on windows (but my new soon-to-arrive notebook will be a
Mac, therefore..
Excel 2007 xlsx files are zip files that contain XML files which
define the spreadsheet -- its all readable text. Create an
Excel 2007 xlsx file, rename its extension to .zip, unzip it
and you can look at all the constituent files using any text
editor or your browser.
On 10/16/07, Marc Schwartz
On 10/16/07, Marc Schwartz <[EMAIL PROTECTED]> wrote:
> On Tue, 2007-10-16 at 14:38 +0100, Arnold Akem wrote:
> > Hey Seniors,
> >
> > Really new to R, please has anyone imported a dataset from MS office
> > excel 2007 into R yet? It seem to be giving me hard times which I did
> > not expect as i
On 17/10/2007, at 7:52 AM, Alberto Monteiro wrote:
> Scionforbai wrote:
>>
>> I just wonder: why should R and its community try to support
>> such an awful program, with its protected formats and unmantained
>> features/bugs?
>>
> By such logic, why should R be ported to Windows? :-)
>
> Short an
Scionforbai wrote:
>
> I just wonder: why should R and its community try to support
> such an awful program, with its protected formats and unmantained
> features/bugs?
>
By such logic, why should R be ported to Windows? :-)
Short answer: because some of the data you want to use
is writen in Excel
o: [EMAIL PROTECTED]; r-help@r-project.org
Subject: Re: [R] Import from excel 2007
I just wonder: why should R and its community try to support such an
awful program, with its protected formats and unmantained
features/bugs?
I mean, from both philosophical and technical point of view: R is free
softwa
I just wonder: why should R and its community try to support such an
awful program, with its protected formats and unmantained
features/bugs?
I mean, from both philosophical and technical point of view: R is free
software and should rather try to be 'viral' than to compete. It
already has the stren
On Tue, 2007-10-16 at 19:21 +0200, Scionforbai wrote:
> > Such workarounds should normally be avoided.
>
> You forgot to mention: Excel should normally be avoided.
>
> Risk of scrambling data while exporting to a simple ascii formatted text file?
> Is it a joke?
No. Excel is notorious for this.
> Such workarounds should normally be avoided.
You forgot to mention: Excel should normally be avoided.
Risk of scrambling data while exporting to a simple ascii formatted text file?
Is it a joke?
__
R-help@r-project.org mailing list
https://stat.ethz.
-project.org
Subject: [R] Import from excel 2007
Hey Seniors,
Really new to R, please has anyone imported a dataset from MS office excel
2007 into R yet? It seem to be giving me hard times which I did not expect
as it use to go well with the previous versions.
Thanks in advance
On Tue, 2007-10-16 at 14:38 +0100, Arnold Akem wrote:
> Hey Seniors,
>
> Really new to R, please has anyone imported a dataset from MS office
> excel 2007 into R yet? It seem to be giving me hard times which I did
> not expect as it use to go well with the previous versions.
>
> Thanks
PROTECTED] On
Behalf Of Arnold Akem
Sent: Tuesday, October 16, 2007 6:38 AM
To: r-help@r-project.org
Subject: [R] Import from excel 2007
Hey Seniors,
Really new to R, please has anyone imported a dataset from MS office excel
2007 into R yet? It seem to be giving me hard times which I did not
Hey Seniors,
Really new to R, please has anyone imported a dataset from MS office excel
2007 into R yet? It seem to be giving me hard times which I did not expect as
it use to go well with the previous versions.
Thanks in advance.
arnoldo
-
23 matches
Mail list logo
