Thursday, 15 December 2011

Bulk insert excel to sql ?

sp_configure 'show advanced options' , 1
RECONFIGURE;
Go
sp_configure 'Ad Hoc Distributed Queries' , 1
RECONFIGURE;
GO

SELECT * INTO ItemTemp FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=D:\StudentDetails.xls', [Sheet1$])

No comments:

Post a Comment