Re: [R] RODBC, sqlFetch error when accessing Excel

You could try read.xls or xls2csv in the gdata package and see how that works. On Thu, Jun 26, 2008 at 4:44 PM, Al Pöhi <[EMAIL PROTECTED]> wrote: > This is about R 2.7.0 and related packages on windows NT. > > I have a mixture of numeric and character data and empty cells in an > Excel spreadshee

[R] RODBC, sqlFetch error when accessing Excel

This is about R 2.7.0 and related packages on windows NT. I have a mixture of numeric and character data and empty cells in an Excel spreadsheet with several tabs that I'm trying to read with sqlFetch from RODBC. The data that is returned by sqlFetch is unfortunately not identical to the source da