title: I have too much data for MS Access. How can I use the data?
body: <p>I have 4 different excel tables. If I import them all into Access I get an error, related to the 2 gigabyte maximum for Access.</p>
  
  <p>I can import the 4 tables as linked tables. However I cannot open them all at once because again, I'll get the same error. I've tried creating a union query shown below, but again I get the same problem.</p>
  
  <p><code>Select * from table1 union all select * from table2 union all select * from table3 union all select * from table4;</code></p>
  
  <p>I'm really at a loss on what I can do. Basically, the 4 tables relate to quarterly sales data and I want to be able to create a pivot table based on the year (either in Excel or Access).</p>
  
  <p>I can combine the 4 tables into 1 excel file, but when trying to create a pivot table I get an error saying there isn't enough RAM on my computer.</p>
  
  <p>What are my options to view this data?</p>