Re: [R] Re ading Excel 5.0 files with RODBC?

Seems like the place where i get those files from has an error somewhere when they create the file which doesn't allow ODBC to see sheet with data, i.e sqlTables returns: [1] TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS <0 rows> (or 0-length row.names) When i open this file in exce

Re: [R] Re ading Excel 5.0 files with RODBC?

On Wed, 8 Apr 2009, Yuri Volchik wrote: 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. RODBC supports any format for which an ODB

Re: [R] Re ading Excel 5.0 files with RODBC?

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 read

Re: [R] Re ading Excel 5.0 files with RODBC?

>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. Thanks for reply David, i was thinking about going this route, the problem is i will have to do it o

Re: [R] Re ading Excel 5.0 files with RODBC?

On Tue, 7 Apr 2009, 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 possi

Re: [R] Re ading Excel 5.0 files with RODBC?

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 f

[R] Re ading Excel 5.0 files with RODBC?

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 for