We have a database of clinical data in Microsoft Access format. We want to work with the data from Postgres. First, we need to extract the data "as is" from Access into Postgres.
[x] In this repo, start a directory called archive and put a copy of the current Access database in it
[x] In this repo, start a directory called scripts, with a requirements.txt
[x] Write a script that extracts the data into Postgres. it looks like you can just use mdbtools for this, but include any scripting needed in the scripts directory
[x] Keep the new Postgres SQL file in the archive directory
Implementation
We have a database of clinical data in Microsoft Access format. We want to work with the data from Postgres. First, we need to extract the data "as is" from Access into Postgres.
See: https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Microsoft_Access
Tasks
archiveand put a copy of the current Access database in itscripts, with arequirements.txtmdbtoolsfor this, but include any scripting needed in thescriptsdirectoryarchivedirectory