thanks for sharing!

[daauerbach]

Thanks for posting up Access-from-R-Mac, I found it helpful to point towards something clunky but functional.

I didn't end up trying the full build from source route since the suggested formula on the mdbtools repo seemed to work ok (brew install mdbtools) to reach command line operations passed as system2 calls (what Hmisc is doing under the hood). I didn't get my standard odbc/DBI connections to work (despite some fiddling with the odbcinst.ini file), but even on a PC I've had pretty limited success passing SQL into Access via dbplyr/odbc translation. But this works to read a table into memory and/or assign and/or pipe to further manipulation.

f <- "path/to/file name that probably has spaces and who knows what else.mdb"
table <- "table_name"
system2(
  "mdb-export", 
  args = paste(stringr::str_replace_all(f, " ", "\\\\ "), "table"), 
  stdout = T) |> 
I() |> readr::read_csv()