Home Forums SQL Server 2005 SQL Server Newbies Stored Procedure and Excel RE: Stored Procedure and Excel

  • December 2, 2009 at 5:52 am

    #1086396

    Will this work for you?

    select *

    into SQLServerTable FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

    'Excel 8.0;Database=D:\testing.xls;HDR=YES',

    'SELECT * FROM [Sheet1$]')