[R-SIG-Finance] Where to download odbcConnectExcel2007

Brian G. Peterson brian at braverock.com
Fri Dec 17 15:03:26 CET 2010


On 12/17/2010 07:39 AM, Stephen Liu wrote:
> Hi Mark,
>
> Ok. Thanks
>
> I was testing "Export to multiple-sheet xls file in R" on a Win7 64bit PC.
>
> On running;
>> xlsFile<- odbcConnectExcel("C:\\Temp\\test.xls", readOnly = FALSE
>
> it complained saying 32 bit odbcConnectExcel can't work.
>
>
> Then I googled around and found;
>
> 4.3.2 Package RODBC
>
> On "R Data Import/Export"
>
> http://bioinformatics.holstegelab.nl/manuals/R/doc/manual/R-data.html
>
> it said "There are versions for Excel 2007 and Access 2007 (go to
> http://download.microsoft.com, select `Office' and search for `ODBC', which will
> lead to AccessDatabaseEngine.exe).
>
>
> Following their link I found the URL in my original posting.
>
>
> I'll post my question on MS Excel forum.

You may also get more help on the r-help list.  the r-data doc is not 
finance specific, even if your work is.

If you do choose to post to R-Help, make sure you proved the 'R' context 
of what you're trying to do.

Regards,

   - Brian

-- 
Brian G. Peterson
http://braverock.com/brian/
Ph: 773-459-4973
IM: bgpbraverock



More information about the R-SIG-Finance mailing list