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
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 be
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? People
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 can we
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 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, *.xlsm,
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 should get
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 in
-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
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
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
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 by
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 answer: because
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
14 matches
Mail list logo