Load Excel from Stored Procedure to SQLTable

• KGC

  Old Hand

  Points: 374

  More actions

  May 23, 2005 at 4:38 am

  #88514

  How can I load an Excel file to a temporary table using a Stored Procedure instead of a DTS?

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  May 23, 2005 at 6:01 am

  #560471

  Research BOL for BCP should have what you need

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net

• Yannis

  Newbie

  Points: 7

  More actions

  May 24, 2005 at 1:55 am

  #560682

  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) as AccGLBridgeOID,

  AccGLCode,

  AccGLFpaCode,

  AccGLFpaPerc,

  convert(int,AccGLXrePis) as AccGLXrePis,

  convert(int,ItemMarkOID)as ItemMarkOID,

  convert(int,NoteTypeOID) as NoteTypeOID

  FROM ExcelSource...sales$