USE [umsatz] 
GO 
DROP TABLE [VERTRETER] 
GO 
 
CREATE TABLE [VERTRETER]
( 
   [VERTRETERNR] [decimal](15, 0) NOT NULL, 
   [FIRMA1] [varchar](40) NULL, 
   [STICHWORT1] [varchar](80) NULL 
) ON [PRIMARY] 
GO 
 
INSERT INTO umsatz.VERTRETER 
   SELECT * FROM OpenQuery("***", 'select VERTRETERNR, FIRMA1, STICHWORT1 from 
   ' VERTRETER') 
GO