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 : 1323 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts