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

From: Gabor Grothendieck <ggrothendieck_at_gmail.com>
Date: Thu, 26 Jun 2008 16:53:18 -0400

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 <tammisiech_at_gmail.com> 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 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 data in that in columns with character values in the
> first few rows the subsequent rows of that column which are filled
> with numeric values are not returned properly but set to <NA>.
> Specifing as.is=T does not help.
> The goal is to read the data from Excel as it is and perform the data
> cleaning in R afterwards.
>
> How can this be fixed?
>
> Regards,
> Al
>
> ______________________________________________
> R-help_at_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.
>



R-help_at_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. Received on Thu 26 Jun 2008 - 20:55:53 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 26 Jun 2008 - 21:31:57 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive