Dear Team,

I have the below problem in excel not sure if Access can be best to solve my below problem.

I pulling 3 different reports from 3 source system say e.g., X source system, Y source system and Z source system.
My requirement is to pull 10 coloumns which are common in those 3 source system into 1 excel file called Conslidated file.
Each month I will have 300,000 line items (approx 100,000 from each source system= 100,000X3= 300,000) combined into 1 excel file.

Problems I face is below:
Say for January Its easy to copy paste 300,000 line items into consolidated file.
But the real problem starts after april when the conlidated file hangs and I could not copy or paste into it because of line items.

Currently I am splitting the consolidated file into 4 consolidated file for each quarters (because of file size) hence I can't have 1 view of data to analyse.

Can anyone help me?

Thanks & Regards,
GP