What to use for simple work with large tables?

Question

Database

Hello!
There is historically accumulated information in 10+ excel files of 100,000+ lines each. One product line - one file. Files are updated ultra-rarely - once a year.
The task is to periodically (once a week) extract information about shipments from one of the 100 branches from each file and glue it into one report table. Even working with each of the files individually is slow. It is not possible to twist files together or make a pimp - Excel crashes (Excel 32bit, 64 is not available).
Advise what to use to collapse all 10+ files into one database and take out the required from it once a week? MS access? I don’t want to make something serious, and I still don’t know how to work with a DBMS ... In fact, I want Excel, which can digest 1 million rows and non-urgently (for example, in a couple of minutes) issue the required report, which can be copied and pasted into a separate file and with poke around at him.
Thanks in advance,
Gleb

Answer 1

if you need to do it quickly - access here is also not very suitable. There is nothing serious in this task, of course.
I would install a free version of the sql server, drive everything into one table and give the sign Department
and your branches from 1 to 100 into it
. And then a simple select. It should fly and there will be nothing complicated.

Answer 2

You can try using something like Qlik