EXEC sp_addlinkedserver 'ExcelSource',
'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'\\xxx.xxx.xxx.xxx\ERP\inventory.xls',
NULL,
'Excel 8.0;HDR=YES;IMEX=1'
EXEC sp_addlinkedsrvlogin 'ExcelSource', false, 'sa', 'pass', NULL
insert into mytable
SELECT
AccGLBridgeOID)...