Using Excel not sure If Access can help

[gpcarthik]

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

[Pepe Le Mokko]

If you are still using XL2003 I' wouldn't know.
If you have 2010 the free PowerPivot add on from MS would help

[alansidman]

Access is not limited to the number of records in a table. It is limited to 2G of data. Once you have the data in one table, what do you wish to do with the data. That is the crucial question that remains unanswered that will determine if Access is a better way. Remember, Access is not a super spreadsheet, but a Relational Data Base System.