Home Forums SQL Server 2008 T-SQL (SS2K8) import data from excel file to sql server database RE: import data from excel file to sql server database

  • December 10, 2010 at 12:10 am

    #1260896

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    IMPORT FROM EXCEL TO TABLE

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    Select * into XLSheet1 from OPENROWSET ('Microsoft.jet.OLEDB.4.0','Excel 8.0;

    database=C:\Latest.xls;',

    'Select * from [Report$]')

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    EXPORT FROM TABLE TO EXCEL

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    INSERT INTO OPENROWSET ('Microsoft.jet.OLEDB.4.0','Excel 8.0;

    database=C:\Latest.xls;',

    'Select * from [Report$]')

    select top 10 * from DataReport