Post
Ask Question

Export Data in Excel using OpenRowset In SQL Server

  1. Insert Into  OPENROWSET('Microsoft.Ace.OLEDB.12.0',  
  2.     'Excel 12.0;Database=D:\Vithal\CSharpcorner.xlsx',   
  3.    'SELECT * FROM [Sheet1$]') Select * From AuthorMaster