Wow, that's a lot of data in an Access database. Does it really have that much data in it? Have you tried doing a compact and repair to see if it can free up some space?
Also there are lots of free database platforms you can take advantage of. You can use SQL Server Express, MySQL, and many others.
Yes it is a lot of data. I work for a large healthcare system. I have compacted and repaired but still i am at my limit. Roughly 6 million rows.
I have never used SQL. This is something i will explore. Thanks!
Back to my original question. There is no way to stack data from multiple databases in tableau, right?
1 of 1 people found this helpful
Sorry for failing to address the original question. Unfortunately, you can't union 2 separate Access databases in Tableau. In fact, union isn't supported for Access at all.
One option might be to use Tableau Prep to merge them together and create a Tableau extract.
I agree with Ken. It's not really useful to store data in access. You can just use a simple database platform. However I would suggest something like sqlite. It's simpler. Then you can use python to get all your data from access and append it to sqlite.
Trust this helps.
Thanks guys. I am going to explore these options and hopefully get back to work!
Oh I still haven't got used to it =) great tool