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
Bookmarks