insert into GJ17_18([cislo zakaznika], [zakaznik nazev], MLFB, GBK, FAGR, PG, datum, mnozstvi, [prijem zakazek], obrat, VSP)

select 
[cislo zakaznika], [zakaznik nazev], MLFB, GBK, FAGR, PG, datum, mnozstvi, [prijem zakazek], obrat, VSP
from 
(
select 
[cislo zakaznika], [zakaznik nazev], MLFB, GBK, FAGR, PG, datum, mnozstvi, [prijem zakazek], obrat, VSP
from GJ16_17
where 0=1
union all

SELECT  a.F1,a.F2,a.F5,a.F3,a.F4,b.PG,now(),a.F9,a.F6,a.F7,a.F8
FROM (select * from [List1$A2:I] IN '' [Excel 12.0 xml;HDR=no;IMEX=1;DATABASE=D:\data\cervenec.xlsx]) a
inner join 
(select * from viBusinessStructure  IN '' [ODBC;Driver={SQL Server Native Client 10.0};Server=myServer;Database=myDatabase;Trusted_Connection=yes;]) b
on a.F4=b.FAGR
WHERE a.F1<>'Overall Result'
)