-
1. Re: Can I Union two access queries together?
Ken Flerlage Jun 7, 2018 1:08 PM (in response to brendan parla)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.
-
2. Re: Can I Union two access queries together?
brendan parla Jun 7, 2018 1:08 PM (in response to Ken Flerlage)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?
-
3. Re: Can I Union two access queries together?
Ken Flerlage Jun 7, 2018 1:13 PM (in response to brendan parla)1 of 1 people found this helpfulSorry 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.
-
4. Re: Can I Union two access queries together?
David Maning Jun 7, 2018 1:13 PM (in response to brendan parla)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
-
5. Re: Can I Union two access queries together?
brendan parla Jun 7, 2018 1:15 PM (in response to David Maning)Excellent.
Thanks guys. I am going to explore these options and hopefully get back to work!
-
6. Re: Can I Union two access queries together?
David Maning Jun 7, 2018 1:16 PM (in response to Ken Flerlage)Oh I still haven't got used to it =) great tool
D