2
Answers

How do i map table from database to already existing excel

Nepethya Rana

Nepethya Rana

7y
162
1
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 
Answers (2)
1
Sundar

Sundar

NA 9.6k 94.4k 7y
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 
0
Nepethya Rana

Nepethya Rana

NA 335 20k 7y
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.