[R] Fwd: Problem with ODBC connection

Jeff Newmiller jdnewmil at dcn.davis.CA.us
Tue Jun 11 06:45:15 CEST 2013


Given the resounding silence, I would venture to guess that no-one here is interested in troubleshooting ODBC connections to Excel. The problem is most likely in the ODBC driver for Excel (not in R or RODBC), and Excel is NOT a database (so any data format problem is unlikely to be detected).
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

Christofer Bogaso <bogaso.christofer at gmail.com> wrote:

>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 at gmail.com>
>Date: Sat, Jun 8, 2013 at 9:39 PM
>Subject: Re: Problem with ODBC connection
>To: r-help <r-help at 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 at 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]]
>
>______________________________________________
>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.



More information about the R-help mailing list