On Apr 7, 2009, at 10:04 AM, Yuri Volchik wrote:
Hi,
i'm trying to read some data from excel files but it seems that
neither
xlsReadWrite nor sqlFetch (RODBC) doesn't like the format (Excel 5.0).
When i open the file in Excel and save it in a new format Excel 97
-2003
everything works fine.
Is it possible to use ODBC connection to open old format files, or i
guess i
will have to open and save every file in Excel in new format, which
isn't
very practical.
If you have a version of Excel that will do all those things, then you
should be able to write a very short VBA macro that will do it.
Undoubtedly simpler than the route you are proposing.
--
David Winsemius, MD
Heritage Laboratories
West Hartford, CT
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
