Hi there,
I am using SQL query to get data from our database to excel with something like this:
select distinct kniha.ucet, ks, right(obd_rr,2) + obd_mm as 'období', NAZEV
from kniha
inner join rozvrh on rozvrh.ucet = kniha.ucet
where obd_mh = '99' and rozvrh.obd_rh = '2017H'
It is pretty...