I'm quite new to QGIS and I'm searching for a simple way to create a Database that allows me to use the tables in QGIS and R. I have a lot of data stored in Excel spreadsheets wich will be used for the statistical analysis in R.
My tasks in more detail: My first task will be visiualizing the data by joining the tables to a shapefile. Tjos Second I want to make some spatial transformations within QGIS with shapefiles and use the newly created data in my statistical analyse. Therefore I will have to join this data to my database.
Last but not least I wan't to assure that the data is stored in a good way for future analises in QGIS and R since the database will be used in other contexts.
Some tolled me that MS Access is a good way to do so. Can anyone of you give me some advice? Maybe on literature and stuff like that too. Thanks in advance!