.Net Special Support
This blogs provides .Net tips and practical solutions
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment