SPONSORS:






User Tag List

Results 1 to 7 of 7
  1. #1
    Junior Member
    Join Date
    Mar 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Two Tables in EXCEL

    Hi,
    I create two tables in Microsoft Excel.
    I populate the first table using SQL Insert statements.
    I am not able to insert values into the second table and display both the tables in the .xls file.
    Can anyone help ??
    Thanks in advance.

  2. #2
    Member
    Join Date
    Mar 2002
    Location
    Pune, MH, India
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Two Tables in EXCEL

    Hi,

    Are you using same worksheet for both the
    tables ?
    Can you elaborate more about problem ?

    [Niteen]


    ------------------

  3. #3
    Junior Member
    Join Date
    Mar 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Two Tables in EXCEL

    Yeah,
    I need to create more than one table in the same excel sheet at runtime and insert values into these tables.


  4. #4
    Senior Member
    Join Date
    Jun 1999
    Location
    Fremont, CA, USA
    Posts
    355
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Two Tables in EXCEL

    Do you need to actually CREATE the sheets, or just access them and add data? The later is easy, I am sure there is also a way to Create a sheet, although I have never tried that.

    ------------------
    David Genrich
    david.genrich@e2open.com
    david@linuxpuppy.net

  5. #5
    Junior Member
    Join Date
    Mar 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Two Tables in EXCEL

    well,
    Let me just elaborate the problem a bit more....
    If I use SQL 'create' command in DB_ExecuteSQL, Iam able to create tables.
    But, the tables are created in different sheets. One sheet each for a table.
    My problem is, I need to create all the tables in just one sheet.
    Ofcourse one can create tables manually on a single sheet and then insert values into.
    But I need to create a .xls file with multiple tables on just one sheet on the fly, at runtime.

  6. #6
    Senior Member
    Join Date
    Jun 1999
    Location
    Fremont, CA, USA
    Posts
    355
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Two Tables in EXCEL

    In Excel, when using queries, each sheet is a table. Thus, I do not believe it is possible to create multiple tables in one sheet, just as you can't create multiple tables in one table in a database (Excel sheet = DB Table).

    Why can't you make multiple sheets in one Excel file, since that is equalivent to multiple tables?

    Excel ~= database
    --------------------
    Excel File = database
    Sheet = table
    column = table label
    row = row



    ------------------
    David Genrich
    david.genrich@e2open.com
    david@linuxpuppy.net

  7. #7
    Member
    Join Date
    Mar 2002
    Location
    Pune, MH, India
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Two Tables in EXCEL

    Hi,
    It is possible to create more than one
    table manually. I have not tried using
    DB_ExecuteSql function.

    To create manually, select table area
    and use menu -
    Insert > Name > Define.
    You will be prompted with "Define Name"
    window. Specify name and click button Add.

    [Yemul]


    ------------------

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

vBulletin Optimisation provided by vB Optimise v2.6.0 Beta 4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.0.9 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Questions / Answers Form provided by vBAnswers (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominatevBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 04:05 PM.

Copyright BetaSoft Inc.