Function reference
-
connectionStringAccess() - Connection String Access
-
createRDatabaseInterface() - Create R-Function Interface to Database
-
currentDb() - Get Path to or Name of Current Database
-
dataFrameToSqlTuples() - Create SQL Tuples from Data Frame
-
dumpDatabase() - Export Database Tables to CSV Files
-
getCurrentSqlDialect() - Get Current SQL Dialect
-
getDatabaseFieldInfo() - Get Information on Table Field Names and Types
-
getDatabaseSchema() - Get Database Schema
-
getFilteredRecords() - Get Filtered Records
-
getNamedExcelRanges() - Get Named Ranges from Excel File
-
getSqlDialect() - Get SQL Dialect from Given Database
-
getTypeIdentifier() - Get Type Identifier
-
hsClearTable() - Clear a Database Table
-
hsCloseDb() - Close Connection to MS Access or Excel
-
hsCloseMdb() - Close Connection
-
hsDropTable() - Drop Database Table(s)
-
hsDumpMdb() - Export Database Tables to CSV Files
-
hsFields() - Available Fields in Database Table
-
hsGetTable() - Get Table from MS Access Database
-
hsGetTimeSeries() - Get Time Series With Timestamp Info
-
hsJetDate() - Date to “mm/dd/yyyy HH:MM:SS”
-
hsLookupOrAddRecord() - Lookup or Add Record
-
hsMdbTimeSeries() - Get Mdb time series in UTC
-
hsOpenDb() - Open Connection to MS Access or Excel
-
hsOpenMdb() - Open Connection to MS Access Database
-
hsPutTable() - Save Data Frame to Database Table
-
hsSetForeignKey() - Set Foreign Key for Table Field
-
hsSetPrimaryKey() - Set Primary Key of Database Table
-
hsSqlExAnd() - SQL Expression “AND”
-
hsSqlExOr() - SQL Expression “OR”
-
hsSqlExTimeCond() - SQL Expression: Time Period
-
hsSqlExTimeGroup() - SQL Expression: Time Grouping
-
hsSqlExTsFields() - SQL Expression: Timestamp Info
-
hsSqlQuery() - Send SQL Query to Database
-
hsTables() - Available tables in database
-
hsTsField() - Available timestamp-field(s) in database table
-
isExcel2003File() - Is this an XLS file?
-
isExcel2007File() - Is this an XLSX file?
-
isExcelFile() - Is this an Excel file?
-
isMySQL() - Is the Given Database of Type MySQL?
-
keyValueToSql() - Generate SQL Filter or Assignment Expression
-
keyValuesToSql() - List of Key = Value Pairs to SQL Expressions
-
keyValuesToSqlAssignment() - List of Key = Value Pairs to SQL Assignment
-
keyValuesToSqlAssignment2() - Key Values to SQL Assignment (2)
-
keyValuesToSqlFilter() - List of Key = Value Pairs to SQL Filter Expression
-
listValuesToSql() - Create SQL Tuples from a List
-
lookupRecord() - Lookup Record
-
merge_relations() - Merge Table Schema with Relationship Information
-
openAdequateConnectionOrStop() - Open Adequate Connection or Stop
-
printDatabaseSchema() - Print Database Schema
-
rcode_DatabaseInterface() - R-code for Functions to Access Database Tables
-
readSqlCommandsFromFile() - Read SQL Commands from File
-
read_relations() - Read Relations from MSysRelationships Table CSV Export
-
read_schemata() - Read Table Schemata from XML Files
-
renamesToFieldList() - List of Renamings to Field Selection String
-
renamesToQueries() - List of Renamings to SQL Queries
-
runSqlCommandsFromFile() - Run SQL Commands from File
-
safeTableName() - Safe Table Name
-
selectFromDb() - Select from Database
-
selectFromTable() - Select from Table
-
setCurrentDb() - Set Current Database
-
setCurrentSqlDialect() - Set Current SQL Dialect
-
sqlForInsert() - Generate SQL INSERT statement
-
sqlForInsertDataFrame() - Generate SQL INSERT Statement
-
sqlForInsertFromSelect() - SQL for INSERT FROM SELECT
-
sqlForInsertIgnoreInMsAccess() - SQL for "INSERT IGNORE" in MS Access
-
sqlForSelect() - Generate SQL SELECT statement#'
-
sqlForSelectByKey() - Generate SQL SELECT Statement
-
sqlForUpdate() - Generate SQL UPDATE Statement
-
sqlFullLeftJoin() - Merge SQL Queries to One Query That Performs a Full Left Join
-
sqlJoinExpression() - Create an SQL JOIN Expression
-
sqlLeftJoin() - Generate SQL for LEFT JOIN
-
sqlLeftJoinBody() - Generate (Base Part of) SQL for LEFT JOIN
-
sqlLeftJoinExpression() - Create an SQL LEFT JOIN Expression
-
xmdb() - Path to example database