How do i map table from database to already existing excel

Question

I already have excel sheet. This excel sheet has some columns with formula. I need to map column from database to excel sheet. How do i do it? Excel sheet has multiple sheets. I need to map the right sheets . Please help me

Sundar · Answer

https://www.aspsnippets.com/Articles/Export-data-from-SQL-Server-to-Excel-in-ASPNet-using-C-and-VBNet.aspx https://www.aspsnippets.com/Articles/Using-SqlBulkCopy-to-import-Excel-SpreadSheet-data-into-SQL-Server-in-ASPNet-using-C-and-VBNet.aspx Follow these links you will get an idea. thanks in advance

Nepethya Rana · Answer

I already have excel sheet. I need to map column from SQL Database and insert the data in excel. Database do not have all columns required for excel Sheet. Some are calculated Columns. and One more thing is that I need to map the data to second sheet of excel.