Dear Prof. Ripley,
 
>You seem not to have tried the simplest possible option.  The following 
>works for me (beware of wrapped lines from mailers)
>
>chan <- odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls);DBQ=C:\\bdr\\hills.xls; ReadOnly=False")
>sqlSave(chan, USArrests, "tests", fast=TRUE) # or FALSE
 
You are right - I have not.
It does not work exactly as it should have but this solves my problem.
I created a very small Excel file odbc1.xls containing 3 sheets (test, Sheet2 and Sheet3).
Below is a short R session:
 
> chan <- odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls);DBQ=C:\\EFGraphs\\odbc1.xls; ReadOnly=False")
 >x<- c(1:6)
 >x <- matrix(x,nrow=3,ncol=2)
 >x <- data.frame(x)
 x
  X1 X2
1  1  4
2  2  5
3  3  6
> sqlSave(chan, x, "test", fast=FALSE)
Error in sqlSave(chan, x, "test", fast = FALSE) : 
        table 'test' already exists
> sqlSave(chan, x, "tests", fast=FALSE)
 
As you see I was unable to overwrite an existing sheet (an attempt to drop this table also fails), but I was able to add a new sheet to an existing Excel file (after this action the file contains 4 sheets - the 3 it contained and the last sheet named tests).
This allows me to do what I wanted, i.e. manually create an Excel file with a small VBA macro, make many copies of this file (under appropriate names), write an appropriate data to each file and then the macro will work on the right data (different for each file).
 
Thanky you!
 
Moshe.

 
 
 




Moshe Olshansky

Chimaera Capital Limited
Level 4 / 349 Collins Street
Melbourne, Victoria 3000
Phone: +613 8614 8400
Fax: +613 8614 8410
Email: molshansky@chimaeracapital.com

Disclaimer: This message is intended only for the personal and confidential use of the designated recipient(s) named above. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communication is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product, an official confirmation of any transaction, or as an official statement of Chimaera Capital Limited. E-mail transmissions cannot be guaranteed to be secure or error-free. Therefore, we do not represent that this information is complete or accurate and it should not be relied upon as such. All information is subject to change without notice.



	[[alternative HTML version deleted]]

