read table from MS Access data base; select and rename columns as defined in renamings table ('old_name' -> 'new_name')

read table from MS Access data base; select and rename columns as defined in renamings table ('old_name' -> 'new_name')

Usage

read_select_rename(
  path_db,
  tbl_name,
  renamings,
  old_name_col = "old_name",
  new_name_col = "new_name"
)

Arguments

path_db

full path to database

tbl_name

name of database table to be read

renamings

name of data frame with renamings

old_name_col

name of column with original variable names

new_name_col

name of column with new variable names