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.


B.R.
Stephen L



________________________________
From: Mark Breman <breman.mark@gmail.com>

Cc: r-sig-finance@r-project.org
Sent: Fri, December 17, 2010 5:53:41 PM
Subject: Re: [R-SIG-Finance] Where to download odbcConnectExcel2007

Hello Stephen,

I think you better ask on a microsoft forum. This is R and finance only...

-Mark-




Hi all,
>
>Win7 64bit
>
>I need to install odbcConnectExcel2007 64 bit
>
>Whether following URL provides it?
>
>Microsoft Data Access Components (MDAC) 2.60.6526.3
>http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a7d785f-c2e0-471d-a33b-82ad1d514737
>
>
>
>TIA
>
>B.R.
>Stephen L
>
>
>
>       [[alternative HTML version deleted]]
>
>_______________________________________________
>R-SIG-Finance@r-project.org mailing list
>https://stat.ethz.ch/mailman/listinfo/r-sig-finance
>-- Subscriber-posting only. If you want to post, subscribe first.
>-- Also note that this is not the r-help list where general R questions should 
>go.
>



	[[alternative HTML version deleted]]

