Excel as Database Reporting Tool

  • Can Excel be used as a database reporting tool?

    I've got a bunch of tables, some of which need to connect to each other when I make a report.

    However, I don't know how to do it in Excel.

    Is Access a better and recommended approach?

    I know there are pivot tables, but I need to make complicated filters and sums first. Is there a way to do this in Excel?

  • Kenshin,

    I would use a combination of both Access and Excel by holding the data in Access tables and then consolidating the tables using queries and then linking to the queries from Excel using a get external data link.

    Depending on the amount of data you have i.e does the number of lines exceed th 65000 limit in Excel you may want to consider using SUMIF formulae in Excel.



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!