subject:"\[R\] using the RODBC for excel"

Re: [R] using the RODBC for excel

2009-08-23 Thread Uwe Ligges

Han Chin Chan wrote: Hi, I am trying to import data directly from an excel spreadsheet using the RODBC package. I am getting the following error messages, wondering if anyone can help me with it? connection = odbcConnectExcel('D:\\R files\\TestData.xls') tables = sqlTables(connection) tab

[R] using the RODBC for excel

2009-08-13 Thread Han Chin Chan

Hi, I am trying to import data directly from an excel spreadsheet using the RODBC package. I am getting the following error messages, wondering if anyone can help me with it? > connection = odbcConnectExcel('D:\\R files\\TestData.xls') > tables = sqlTables(connection) > tables TABLE_CAT T