Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Load Excel from Stored Procedure to SQLTable

    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)...

Viewing post 1 (of 1 total)