Any response please? Was my question not clear to the list? Please let me
know.

Thanks and regards,

---------- Forwarded message ----------
From: Christofer Bogaso <bogaso.christofer@gmail.com>
Date: Sat, Jun 8, 2013 at 9:39 PM
Subject: Re: Problem with ODBC connection
To: r-help <r-help@r-project.org>


Hello All,

My previous post remains unanswered probably because the attachment was not
working properly.

So I am re-posting it again.

My problem is in reading an Excel-2003 file through ODBC connection using
RODBC package. Let say I have this Excel file:

http://www.2shared.com/document/HS3JeFyW/MyFile.html


I saved it in my "F:" drive and tried reading the contents using RODBC
connection:

> library(RODBC)
> MyData <- sqlFetch(odbcConnectExcel("f:/MyFile.xls"), "aaaa")
> head(MyData, 30)


However it looks that the second column (with header 's') is not read
properly.

Can somebody here explain this bizarre thing? Did I do something wrong in
reading that?

Really appreciate if someone could point out anything what might go wrong.

Thanks and regards,


On Fri, Jun 7, 2013 at 4:46 PM, Christofer Bogaso <
bogaso.christofer@gmail.com> wrote:

> Hello again,
>
> I am having problem with ODBC connection using the RODBC package.
>
> I am basically trying to read the attached Excel-2003 file using RODBC
> package. Here is my code:
>
> > head(sqlFetch(odbcConnectExcel("d:/ssss1.xls"), "aaaa"), 30);
> odbcCloseAll()
>    Criteria  s  d fd  f                        fd1
>     f1                        fd2    f2 fd3 f3 F12 F13 F14 F15 F16 F17
> F18 F19 F20
> 1         a NA NA NA NA 0.000000000000000000000000
> 0.000000000000000027755576 -0.00000000000000040332321    NA  NA NA  NA
>  NA  NA  NA  NA  NA  NA  NA  NA
> 2         s NA  0 NA NA 0.000000000000000000000000
> 0.000000000000000000000000  0.00000000000000000000000    NA  NA NA  NA
>  NA  NA  NA  NA  NA  NA  NA  NA
> 3         d NA  0 NA NA 0.000000000000000001734723
> 0.000000000000000006938894  0.00000000000000002775558  5.00  NA NA  NA
>  NA  NA  NA  NA  NA  NA  NA  NA
> 4         f NA NA NA NA                         NA
>     NA                         NA -4.25  NA NA  NA  NA  NA  NA  NA  NA
>  NA  NA  NA
> 5         f NA  0 NA NA 0.000000000000000000000000
> 0.000000000000000000000000  0.00000000000000000000000 -1.53  NA NA  NA
>  NA  NA  NA  NA  NA  NA  NA  NA
> 6         f NA NA NA NA                         NA
>     NA  0.00000000000000000000000  0.00  NA NA  NA  NA  NA  NA  NA  NA
>  NA  NA  NA
> 7         f NA NA NA NA                         NA
>     NA  0.00000000000000000000000    NA  NA NA  NA  NA  NA  NA  NA  NA
>  NA  NA  NA
> 8         f NA  0 NA NA                         NA
>     NA                         NA    NA  NA NA  NA  NA  NA  NA  NA  NA
>  NA  NA  NA
> 9         f NA  0 NA NA                         NA
>     NA                         NA    NA  NA NA  NA  NA  NA  NA  NA  NA
>  NA  NA  NA
> 10        f NA NA NA NA                         NA
>     NA                         NA    NA  NA NA  NA  NA  NA  NA  NA  NA
>  NA  NA  NA
> 11        f NA NA NA NA                         NA
>     NA                         NA    NA  NA NA  NA  NA  NA  NA  NA  NA
>  NA  NA  NA
> 12        f NA NA NA NA                         NA
>     NA                         NA    NA  NA NA  NA  NA  NA  NA  NA  NA
>  NA  NA  NA
> 13        f NA NA NA NA                         NA
>     NA                         NA    NA  NA NA  NA  NA  NA  NA  NA  NA
>  NA  NA  NA
>
> Here you see the data in second column could not read at all.
>
> Can somebody point me if I did something wrong?
>
> Thanks and regards,
>

	[[alternative HTML version deleted]]

