OleDbConnection conn = new OleDbConnection(connectionString) + path + " Extended Properties=\"Excel 12.0 Xml HDR=NO\" " string connectionString = "Provider=.12.0 Data Source=" Here is a code example you could refer to. If 'Streamdata$E4:E5:E6:E7:E8:E9:E10:E11:E12' is not a local object, check your network connection or contact the server Nitin Sharma, Welcome to Microsoft Q&A, based on my test, I reproduced your problem.Īccording to my research, I find that Oledb only support rows inserting instead of columns inserting. Make sure the object exists and that you spell its name and the path name correctly. The Microsoft Access database engine could not find the object 'Streamdata$E4:E5:E6:E7:E8:E9:E10:E11:E12'. I have also tried with different sheet name. Make sure that it does not include invalid characters or punctuation and that it is not too long.' I am using below query but getting the error. How can I write to multiple specific cells in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |