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 : 768 | 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?

manimala


Responses

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

Up
0
Down
Check "Import vs. Append " section under this link
http://support.microsoft.com/kb/321686

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
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

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

Login to post response