Welcome to Sign in | Help

Re: script de import din excel in SQL Server 2000

  •  07-18-2007, 8:50 PM

    Re: script de import din excel in SQL Server 2000

    [1] In versiunea SQL Server 2000 ai la dispozitie DTS - Data Transformation Services pentru exportul si importul datelor din / in SQL Server (incluziand aici importul intr-o baza de date SQL Server a datelor dintr-un workbook Excel). SQL Server Integration Services (SSIS) este urmaşul lui DTS.

     

    [2] Totusi solutia cea mai simpla pp. utilizarea functiei OPENROWSET:

     SELECT Q.*
    INTO tabel
    FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\Book1.xls', [Sheet1$]) AS Q

     

     [3] altele ...OpenDataSource , LinkedServer ...

     

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems