Create an mdbr DBI Driver

Source: R/dbi.R

mdb() is the canonical DBI-style constructor for connecting to Microsoft Access '.mdb' and '.accdb' files. dbSendQuery() currently materializes SQL results eagerly; for a streaming named table use mdb_stream_table(). Existing export helpers remain eager and should not be used for bounded- memory conversion.

mdb()

Value

A DBI driver for '.mdb' and '.accdb' files.

Examples

db <- mdb_example()
conn <- DBI::dbConnect(mdb(), dbname = db)
DBI::dbListTables(conn)
#> [1] "Order Details" "Orders"        "Products"      "Shippers"     
#> [5] "Categories"    "Customers"     "Employees"     "Suppliers"    
#> [9] "Umsätze"      
DBI::dbDisconnect(conn)
#> [1] TRUE