Excel as database question
Results 1 to 6 of 6

Thread: Excel as database question
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Oct 2002
    Posts
    146
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel as database question

    I download an entire trial balance from our accounting software into excel. I then map out each account to create a balance sheet. Works like a charm...

    However, I need to re-download a month that was corrected in the accounting software. While I can manually delete the rows and paste the new data, I obviously want to do it better.

    I tried using Microsoft BI, but it slowed my PC to a crawl.

    I started reading about using excel as a database management tool, but I haven't found how to easily update existing info with new info.

    If someone can point me in a direction...I would appreciate it...

    ty

  2. #2
    Board Regular Logit's Avatar
    Join Date
    Aug 2016
    Location
    United States
    Posts
    2,723
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Excel as database question

    .
    Depends on what you mean by "updating existing info".

    If it will be a 'one time thing' perhaps just a copy / paste to the right area of the correct sheet.
    If you are speaking in terms of doing a search for a term, locating that term and all the data attached to it which is populated to a row on
    a worksheet ... perhaps a more involved approach using VBA macros would be in order.

    ???

  3. #3
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,406
    Post Thanks / Like
    Mentioned
    54 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Excel as database question

    Any thoughts/possibility of actually using a "database" program, like Access, instead of Excel?
    As you have discovered, you can use Excel as a database, but it doesn't necessarily work all that well, since Excel isn't really a database program.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  4. #4
    Board Regular
    Join Date
    Oct 2002
    Posts
    146
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel as database question

    Joe,
    I thought about using access, but i have limited experience there...I am on the fence about the time needed to get get up to speed with access vs some type of cut and paste two or three times a month...

  5. #5
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,406
    Post Thanks / Like
    Mentioned
    54 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Excel as database question

    You are right, in order to design a well-working Access database, it would take some time to get up-to-speed, not just on Access, but on Relational Database Design (especially the Rules of Normalization).
    But if performance is a major concern, it may be something to look into. Perhaps enlist the help of an Access consultant to help you set it up?
    Like wise, you may be able to enlist an experienced Excel consultant to help you make your Excel "database" more efficient.
    Just something to keep in mind.

    If you want to try to do it yourself, that is fine, but I think you are going to need to provide more specific details in your questions (generic questions usually can only lead to generic replies, which may not help you that much).
    Last edited by Joe4; Mar 29th, 2019 at 08:04 AM.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  6. #6
    Board Regular
    Join Date
    Oct 2002
    Posts
    146
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel as database question

    I hear ya...on all points...

    For now, I think forging ahead and tweaking as I go is the plan...the whole "re-downloading of data" might not be as much of an issue as the time it may take to automate the task...

    thanks...

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
  •