is there any possibility to replace the db table columns with excel sheet?

Posted by Tejamanimala under ASP.NET on 11/14/2013 | Points: 10 | Views : 1201 | Status : [Member] | Replies : 1
hi i have an application which is used to import the excel sheet data into table,for that i created the same columns in excel sheet and in db able.but now my doubt is i want to replace that columns with new excel sheet columns,how it is possible can any one please tell me?



Posted by: Bandi on: 11/14/2013 [Member] [MVP] Platinum | Points: 25

Check "Import vs. Append " section under this link

It directly creates new table for excel data export with the help SELECT * INTO ... FROM SheetName

Before creating this new table drop existing table...

Mark This Response as Answer

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

Login to post response