I am creating a spatial database for five buildings for a project that I am working on. I have spatial data in the form of a shapefile and attribute data in Microsoft Access(with a table and queries). There is a common field "TOTAL_AREA(m.sq)" for both spatial and attribute data.
I would like to join both attribute and spatial data in QGIS to create the spatial database. I tried to load the MS Access Database using ODBC Data sources but nothing showed.
Is there a way to do this without using ODBC?
I am using a Windows10 Operating system with QGIS 3.4, 64 bit.