Simple database interface for RODBC Excel.


[Up] [Top]

Documentation for package ‘easyrodbcexcel’ version 0.7.6

Help Pages

easyrodbcexcel-package Simple database interface for RODBC Excel.
easyrodbcexcel Simple database interface for RODBC Excel.
edbColnames.RODBC_Excel Retrieve column names of a table in a MS Excel file (referenced by 'edb').
edbDelete.RODBC_Excel NOT SUPORTED FOR EXCEL. Delete all or some rows in a table in a MS Excel file (referenced by 'edb').
edbDrop.RODBC_Excel Drop a table in a MS Excel file (referenced by 'edb').
edbNames.RODBC_Excel Retrieve table names in a MS Excel file (referenced by 'edb').
edbNRow.RODBC_Excel Retrieve the number of rows of a table in a database (referenced by 'edb').
edbQuery.RODBC_Excel Send and retrieve a query in an MS Excel database (referenced by 'edb').
edbRead.RODBC_Excel Read all or part of a table in a MS Excel file (referenced by 'edb').
edbWrite.RODBC_Excel Write data in a MS Excel table in a database (referenced by 'edb').
[.RODBC_Excel "[" method for reading all or part of a table in a MS Excel file (referenced by 'edb').
[<-.RODBC_Excel "[<-" method for MS Excel files. Write data in a MS Excel table in a database (referenced by 'edb').