Re: [R] Problem with ODBC connection

2013-06-08 Thread Christofer Bogaso
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

[R] Problem with ODBC connection

2013-06-07 Thread Christofer Bogaso
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:/1.xls"), ""), 30); odbcCloseAll() Criteria s d fd f