Primavera is showing PC is out of memory when importing from excel

I just received a question about Primavera from one of our website courses member and i believe it is interesting. Following is the question and my answer:

“Dear Mr.Hany,

When im importing almost 6000 activities from excel to Primavera it is showing PC is out of memory and close other programs   and i close other programs but it takes too much time. is there any solution for this? pls…”

I have faced similar situation and i found that the solution is very simple. Just separate your file into 3 patches, each patch 2000 activity. In another words, divide your excel sheet into three sheets and import one by one. This is the easy solution, the hard solution is to check the following:

1- You have enough memory installed in your PC (around 4GB).

2- You have enough space in your C drive (around 20 GB).

3- You do not have lot of programs working in the background (check this by typing ALt+Ctrl+Delete and check/close programs in the task manager).

4- If the above 3 check list is okay and you still have problems, then i would advice to reinstall the windows and P6.

5- If you still have problem, change the Primavera version.