String ddlValue = ddlImportType.SelectedValue Protected void Page_Load(object sender, EventArgs e) Private String strConnection ="Data Source=SENPWM10519387\\SQLEXPRESS Initial Catalog=QATest Integrated Security=True" please help meĪnyway your all asp.net programm and example is The provider did not give any information about the error.Ĭannot initialize the data source object of OLE DB provider ".4.0" for linked server "(null)" The OLE DB provider ".4.0" for linked server "(null)" reported an error. INSERT INTO OPENROWSET ('.4.0', 'Excel 8.0 Database=D:\contact.xlsx ',
#What if excel cannot locate server for external data 2011 how to#
I want to create procedure use this procedure in asp.net after clicking the button sql data is transfer into excel format how to do this i am trying to create query to transfer data sql to excelĮXEC sp_configure 'show advanced options', 1 ĮXEC sp_configure 'Ad Hoc Distributed Queries', 1 SqlBulk.DestinationTableName = "Excel_table" SqlBulkCopy sqlBulk = new SqlBulkCopy(strConnection) OleDbCommand cmd = new OleDbCommand("Select, from ", excelConnection)
Create OleDbCommand to fetch data from Excel OleDbConnection excelConnection = new OleDbConnection(excelConnectionString) String excelConnectionString = Source=" + Server.MapPath("orders.xlsx") + " Extended Properties=Excel 12.0 Persist Security Info=False" Create connection string to Excel work book String path = įileuploadExcel.SaveAs(Server.MapPath("orders.xlsx")) Protected void btnSend_Click(object sender, EventArgs e) Hi all who is having problem of "The Microsoft Office Access database engine could not find the object 'Sheet1$'"