Access

Query MS Access files via JDBC and UCanAccess.

Example

Read data from Access database

using Access

fn = "C:\\temp\\TestDatabase.accdb"
df = Access.query(fn, "SELECT * FROM Person WHERE BirthYear > 1980")

Modify data in Access database

# Read table content to DataFrame
StoredValues = Access.query(fn, "SELECT * FROM StoredValues;");

# Delete everything in table
Access.query!(fn, "DELETE * FROM StoredValues;")

# Re-insert data from DataFrame (inserting into table with same name as DataFrame)
Access.@insertdf(fn, StoredValues)

# Alternatively, specify table explicitly:
Access.insertdf(fn, StoredValues, "StoredValues")