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.

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.

Hi Brendan,

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.

D

Oh I still haven't got used to it =) great tool

D