Need Help: 2 or more access database files into 1 pivot table - (2010 ver)

[neilbomb123]

Hi All,

I have limited knowledge with MS Access. I'm using it as a pivot table source due it my raw data is a bit big for an excel worksheet alone.

I am currently using Office 2010. I have 2 access database files which has 1 table in it each. The first file has reached it max GB limit so I created a new one to put in the other raw data. (running YTD worth of data).

What I'm trying to achieve is to use these 2 access database files into one pivot table. How can i do this?

Really appreciate any answers/reply.

Thank you.

 

[anvg]

Hi
Simple create query for union tables from old and new databases and use them for pivoting

Select * From [;Database=d:\Path\oldDatabaseName.accdb].[OldTableName] as t1
union
Select * From TableNameInNewDatabase

Or link the table from the old database to the new database and union them together

Select * TableNameInNewDatabase
Union
Select * LinkTableName

Regards,

 

[neilbomb123]

Thank you. Will try this.