Displaying 3 results from an estimated 3 matches for "sorkinjohn".
2009 Jun 25
0
RODBC: Trying to read an Excel file
Try the function sqlFetch to import the data in the spreadsheet.
jo<-odbcConnectExcel("i:\\all\\sorkinjohn\\stats\\silvermannatalie\\NEMOcomb
ined06-24-09.xls",readOnly = TRUE)
mo<-sqlFetch(jo,'Your Sheet Name or Number',colnames=F,rownames=F)
mo
Hope it helps.
-------------------------------------------------------------
MSc. Rodrigo Aluizio
Centro de Estudos do Mar/UFPR
Laborat?rio...
2009 Jun 25
1
RODBC 1.2-6 on CRAN, future directions
Version 1.2.6 of RODBC is now on CRAN. This has a number of bug fixes and many
workarounds for ODBC driver quirks--I've set up further testbeds for SQL Server
2008, Oracle and DB2.
More visibly, the documentation has been expanded in several ways, in
particular in collecting together advice on using 'schemas' and 'catalogs' in
the ?RODBC overview.
There is also a test
2009 Jun 25
1
RODBC 1.2-6 on CRAN, future directions
Version 1.2.6 of RODBC is now on CRAN. This has a number of bug fixes and many
workarounds for ODBC driver quirks--I've set up further testbeds for SQL Server
2008, Oracle and DB2.
More visibly, the documentation has been expanded in several ways, in
particular in collecting together advice on using 'schemas' and 'catalogs' in
the ?RODBC overview.
There is also a test