Torna al Thread

UPDATE N SET col1 = E.Col1, Col2 = E.Col2, ...Col_n = E.Col_n FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=c:\temp\DatiNegozi.xls', [Sheet1$]) AS E JOIN dbo.Negozi AS N ON E.PK = N.PK;
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5