insert into testBS(
	FagrTreeId,
	FAGR,
	PG,
	GBK,
	Segment,
	BusinessUnit,
	Division,
	PgTreeid,
	CSGBK,
	CSGBKId) in '' [ODBC;Driver={SQL Server Native Client 10.0};Server=MyServer;Database=TempDB;Trusted_Connection=yes;]
select 
	FagrTreeId,
	FAGR,
	PG,
	GBK,
	Segment,
	BusinessUnit,
	Division,
	PgTreeid,
	CSGBK,
	CSGBKId 
from viBusinessStructureTreeExpanded  IN '' [ODBC;Driver={SQL Server Native Client 10.0};Server=MyServer;Database=MyDatabase;Trusted_Connection=yes;]

          insert into GJ17([id], [name], MLFB, GBK, FAGR, PG, datum, mnozstvi, avans, obrat, VSP)  
IN '' [ODBC; Driver={SQL Server Native Client 10.0}; Server=MyServer;Database=MyDatabase;Trusted_Connection=yes;])
 
                    select [id], [name], MLFB, GBK, FAGR, PG, datum, mnozstvi, avans, obrat, VSP
                    from 
                    (                    (
                    select [id], [name], MLFB, GBK, FAGR, PG, datum, mnozstvi, avans, obrat, VSP 
                    from GJ17
                    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\GJ17.xlsx]) a 
                    left join 
                    (select* from viBusinessStructureTreeExpanded 
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' and a.F1 is not null 
                    ) tmp