Thanks for reply David, but the problem is that the place i get those files from saves them in the old Excel format (Excel 5.0), not Excel 97-2003, so neither of the packages (RODBC, xlsReadWrite) can read it.
>Your question is a bit confusing. This is the current state of play >regarding reading and writing Excel files with xlsReadWrite and RODBC. > >xlsReadWrite will read and write from Excel 97-2003 files (.xls files) >including reading from named sheets, but only writing a single sheet >workbook. Regards, Yuri -- View this message in context: http://www.nabble.com/Reading-Excel-5.0-files-with-RODBC--tp22929781p22944550.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ 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.