Access has a fatal flaw of a 2GB limit, which when combined with other problems means it's not usable.
MariaDB
Available from mariadb.org, choose the Windows 64 msi download.
Set up as service, use a root password, otherwise defaultssdefaults.
Download the java connector.
GUI: dbForge Studio
This tool can import the UCRex csv files without problem.
DEMOGRAPHICS
The STUDY_ID field is the key, so edit the type to set to primary key. However, it is in hex format. The type should be changed to VARCHAR with length 32. The default type is BLOB, but this can't be used as a primary key (see why).
...
Access (obsolete for larger datasets)
Access has a fatal flaw of a 2GB limit, which when combined with other problems means it's not usable.
Importing into Access
The raw csv format tables can be imported as "Text File" (External Data tab).
Load PATIENT_ID as Short Text, since Long Integer is too short, and double has problems (at least 10 selected PATIENT_ID's would not match when used to select using the same ID).
Demographics
Import this as a table Patients. Let Access create a primary key and rename that to SubjectID.
Diagnoses
Set ENCOUNTER_ID to Short Text.
...