Results 1 to 4 of 4

Thread: Database in Excel
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2018
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Database in Excel

    Hi, is it possible to create a database in excel? What I mean is, can I save details from a worksheet to a different worksheet then I can query it up when needed?

    If not, can you suggest alternatives? Thanks

  2. #2
    Board Regular
    Join Date
    Jul 2014
    Location
    Memphis, TN
    Posts
    2,677
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Database in Excel

    Quote Originally Posted by rparedes View Post
    Hi, is it possible to create a database in excel? What I mean is, can I save details from a worksheet to a different worksheet then I can query it up when needed?

    If not, can you suggest alternatives? Thanks
    Details? More detail on the details...
    Excel 2013, 2016 with PowerBI
    Knowing that it can be done is half the battle!

  3. #3
    New Member
    Join Date
    Sep 2018
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Database in Excel

    Quote Originally Posted by SpillerBD View Post
    Details? More detail on the details...

    Sorry, my english wasn't clear. What I meant was, if I have some data (i.e. Full Name, Address, DOB, Salary) can I create some sort of database in the same excel file?

  4. #4
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,872
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Database in Excel

    this is a kind of db in Excel

    Date ID Name Company Country City Sales
    21/03/2018 16850307-6211 Felix Weiss Sem LLP Sierra Leone Feldkirchen in Kärnten
    32638
    18/04/2018 16300905-7245 Maggy Z. Cruz Malesuada Augue Corp. Tonga Curacautín
    42560
    02/08/2017 16910128-2987 Melyssa Hale Mi Corporation Liechtenstein Temuka
    18179
    19/01/2018 16340924-6224 Beau E. Colon Ultrices Iaculis Odio Corporation Kazakhstan Gouvy
    33995
    01/06/2018 16490821-7609 Brenden Roach Nulla Aliquet PC Botswana Meerdonk
    15790
    23/04/2017 16590903-0263 Ahmed U. Joyner Nec Cursus LLP Fiji Monte Patria
    36711


    you can get details in many different ways in the same workbook (or different workbook if you wish)

    for BigData (millions of rows, many tables) I suggest Access, SQL, InnoDB or any similar
    Last edited by sandy666; Jul 17th, 2019 at 08:36 AM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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