how to replace the table columns when uploading excel sheet?

Posted by Tejamanimala under ADO.NET on 11/12/2013 | Points: 10 | Views : 870 | Status : [Member] | Replies : 2
hi,i have a application in which need to upload a excel sheet into database and retrieve that from database,for that i have tried and its success,for this i maintain the columns of table and excel columns are same,but now my requirement is,when i upload a excel sheet into database table,table columns and data should be replace with the new excel sheet,how it is possible?,

manimala


Responses

Posted by: vishalneeraj-24503 on: 11/12/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Hi, Please refer below links :-

http://www.codeproject.com/Questions/681243/HOW-TO-READ-EXCEL-SHEET-AND-INSERT-A-NEW-COLUMN-IN
http://office.microsoft.com/en-in/access-help/import-export-and-link-data-between-access-and-excel-HP001095095.aspx

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Tejamanimala on: 11/12/2013 [Member] Starter | Points: 25

Up
0
Down
hey that link is not opening

manimala

Tejamanimala, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response