How to Delete Old Records from an Excel File Using ASP.Net and Visual Basic .NET

Discussion in 'ASP .Net' started by Mahesh Kumar, Oct 25, 2003.

  1. Mahesh Kumar

    Mahesh Kumar Guest

    hi,

    I have two excel files(a1.xls and b.xls) each having 4
    sheets. I want to read datas of 4 sheets from b1.xls and
    it has to be inserted in a1.xls as 4 sheets. First it has
    to delete all datas in all sheets and then insert the
    datas of b1.xls into a.xls.

    I'm using ADo.Net, ASP.Net and Visual Basic.Net.

    thanks

    Mahesh
    Mahesh Kumar, Oct 25, 2003
    #1
    1. Advertising

  2. You may want to try opening the spreasheets as ADO data sources.
    Here's more information on that:
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;278973

    --
    I hope this helps,
    Steve C. Orr, MCSD, MVP
    http://Steve.Orr.net
    Hire top-notch developers at http://www.able-consulting.com



    "Mahesh Kumar" <> wrote in message
    news:05ad01c39ac7$c0e10e50$...
    > hi,
    >
    > I have two excel files(a1.xls and b.xls) each having 4
    > sheets. I want to read datas of 4 sheets from b1.xls and
    > it has to be inserted in a1.xls as 4 sheets. First it has
    > to delete all datas in all sheets and then insert the
    > datas of b1.xls into a.xls.
    >
    > I'm using ADo.Net, ASP.Net and Visual Basic.Net.
    >
    > thanks
    >
    > Mahesh
    Steve C. Orr [MVP, MCSD], Oct 25, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. M P
    Replies:
    6
    Views:
    537
    Joe Fallon
    Aug 7, 2004
  2. Replies:
    3
    Views:
    7,747
    elizas
    Apr 27, 2010
  3. Stewart
    Replies:
    1
    Views:
    514
    Ken Cox [Microsoft MVP]
    Feb 24, 2006
  4. hunkgym
    Replies:
    1
    Views:
    1,971
    =?Utf-8?B?TGVvbiBNYXluZQ==?=
    Oct 30, 2006
  5. Dan

    Delete records or update records

    Dan, May 10, 2004, in forum: ASP General
    Replies:
    1
    Views:
    455
    Ray at
    May 10, 2004
Loading...

Share This Page