sql and excel

Discussion in 'ASP .Net Web Controls' started by shiney agarwal via .NET 247, Jun 10, 2004.

  1. (Type your message here)
    hello.
    can we insert data in sql as well as in excelsimulatenously.basically i want to use excel to draw charts so iwant my data from sql to move into excel and display the graph.im using vb.net.kindly help as soon as possible as my projectpresentation is on head.plz tell me either of the ways.. i.einsertion of data can be done in excel as well as sql or how toshift the data.
    thank you,
    --------------------------------
    From: shiney agarwal

    -----------------------
    Posted by a user from .NET 247 (http://www.dotnet247.com/)

    <Id>A5m4YL7PcEuVRJf0MItDDQ==</Id>
     
    shiney agarwal via .NET 247, Jun 10, 2004
    #1
    1. Advertising

  2. shiney agarwal via .NET 247

    Owen Evans Guest

    Not really on topic for this group, but yes, it can be done. Do it manully
    with the Excel macro recorder running, and then translate the generated vba
    into vb.net. Please post followups to microsoft.public.excel.programming.

    "shiney agarwal via .NET 247" <> wrote in message
    news:...
    (Type your message here)
    hello.
    can we insert data in sql as well as in excel simulatenously.basically i
    want to use excel to draw charts so i want my data from sql to move into
    excel and display the graph.i m using vb.net.kindly help as soon as possible
    as my project presentation is on head.plz tell me either of the ways.. i.e
    insertion of data can be done in excel as well as sql or how to shift the
    data.
    thank you,
    --------------------------------
    From: shiney agarwal

    -----------------------
    Posted by a user from .NET 247 (http://www.dotnet247.com/)

    <Id>A5m4YL7PcEuVRJf0MItDDQ==</Id>
     
    Owen Evans, Jun 10, 2004
    #2
    1. Advertising

  3. "Owen Evans" wrote ...

    > hello.
    > can we insert data in sql as well as in excel simulatenously.basically i
    > want to use excel to draw charts so i want my data from sql to move into
    > excel and display the graph.i m using vb.net.kindly help as soon as possible
    > as my project presentation is on head.plz tell me either of the ways.. i.e
    > insertion of data can be done in excel as well as sql or how to shift the
    > data.
    > thank you,


    I'm sorry, I don't understand you. If I substitute 'SQL Server' for
    'sql' in your post, it makes more sense. So assuming this...

    You can use sql the *language* via ADO.NET to insert (push) data into
    both SQL Server and Excel data sources, one query for each. You can
    execute both queries asynchronously if desired.

    Alternatively you could have VBA code embedded in the Excel workbook
    (client) to remotely query the SQL Server data (server).

    More details on what you are trying to achieve, please.

    Jamie.

    --
     
    Jamie Collins, Jun 11, 2004
    #3
    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. acool
    Replies:
    0
    Views:
    310
    acool
    May 6, 2004
  2. Luis Esteban Valencia
    Replies:
    1
    Views:
    1,394
    Carl Prothman [MVP]
    Jan 12, 2005
  3. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    1,512
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
  4. ecoolone
    Replies:
    0
    Views:
    762
    ecoolone
    Jan 3, 2008
  5. Belinda
    Replies:
    4
    Views:
    364
    Bob Barrows [MVP]
    Jun 11, 2004
Loading...

Share This Page